PDA

View Full Version : Opening Access From Excel Macro - Security Warning



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!

sicko976
12-06-2007, 08:19 AM
You might be able to use a Findwindow and Sendkey code combination.