OLE action message

[Molby]

Hi All,

I am running a macro in Access from Excel using:

Set acApp = CreateObject("Access.Application&quot
acApp.Visible = True
acApp.OpenCurrentDatabase ("CATABASE.mdb&quot
acApp.DoCmd.RunMacro "MacName"

However it takes a long time to run, and Excel keeps giving me a message saying, "Microsoft Excel is waiting for another application to complete an OLE action." Is there a way of switching this off, or extending the time that Excel waits for OLE actions?

Thanks,

Ian

 

[TheBitDoctor]

try Application.ODBCTimeout = Wait_in_Seconds

Setting the wait to zero waits forever.

I don't know if it will affect ActiveX objects but its worth a shot. Also, have you tried turning off Excel messages?

Application.Displayalerts = False

You can also try setting up Access using the shell command , AppActivate, and SendKeys with the wait parameter set to false. But, that's much more tricky and prone to timing issues.