Opening Access From Excel Macro - Security Warning

[eddydow]

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!

[sicko976]

You might be able to use a Findwindow and Sendkey code combination.