Opening Access From Excel Macro - Security Warning
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!