Schedule Macro

[Natalie]

Hi,
I use the following script to schedule a macro
"C:\Program Files\Microsoft Office\OFFICE11\MSACCESS.EXE"
"E:\apps\MasterData\Weekly\Reports\DepOps.mdb" /x WklyChanges. This runs the
macro just fine, but it opens the database and the script while it's being
executed. After it finishes both the database and the script is left
open...I have to manually close it at all time. How can I close both
database and script after it finishes execution?

Thanks for all your help!
Natalie

 

[Steve Schapel]

Natalie,

In answer to the second question, I think you need to put a Quit action
at the end of the WklyChanges macro.

As for the "script", I guess it depends where you are running this from.
Are you using Windows Task Manager, or a third party scheduling
utility, or a batch file?

 

[Natalie]

The script I am referring to is a batch file that i scheduled in windows task
manager.

 

[Steve Schapel]

Natalie,

I am not sure why the DOS window is opening to run the batch file. But
anyway, I think you don't need the batch file, as I think you can write
the Command Line directly into the task scheduler.

 

[Candyman]

This ALMOST got me there. I am not sure what to put in the Run: text box . .
or does something go in the start In: box???