eddydow
11-27-2007, 06:30 AM
Hi,
I am working on an excel macro that opens an Access program and was wondering if there is a way to have my excel macro "click open" when the Security warning message comes up in Access (instead of having to manually click enter with my mouse). I have the code below which gets me to the point where the Security warning box pops up...
LPath = Range("A25")
Set oApp = CreateObject("Access.Application")
oApp.Visible = True
oApp.OpenCurrentDatabase LPath
oApp.DoCmd.SetWarnings False
Any help would be greatly appreciated. Thanks!
I am working on an excel macro that opens an Access program and was wondering if there is a way to have my excel macro "click open" when the Security warning message comes up in Access (instead of having to manually click enter with my mouse). I have the code below which gets me to the point where the Security warning box pops up...
LPath = Range("A25")
Set oApp = CreateObject("Access.Application")
oApp.Visible = True
oApp.OpenCurrentDatabase LPath
oApp.DoCmd.SetWarnings False
Any help would be greatly appreciated. Thanks!