Macro Execution from Windows Scheduler

  • Thread starter Thread starter TomT
  • Start date Start date
T

TomT

I have some large queries that need to be run off hours. I have setup a
macro to run them all.

How can I trigger the execution of this macro from windows scheduler?

Thanks,

TomT
 
Tom,

Set the Command Line in the task scheduler like this:

"C:\Program Files\...\Msaccess.exe" "C:\YourFolder\YourDatabase.mdb" /x
NameOfYourMacro
 
Steve,

Thanks!!! Works like a champ.

TomT

Steve Schapel said:
Tom,

Set the Command Line in the task scheduler like this:

"C:\Program Files\...\Msaccess.exe" "C:\YourFolder\YourDatabase.mdb" /x
NameOfYourMacro
Click to expand...
 
Back
Top