Schedule Macro

N

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
 
S

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?
 
N

Natalie

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

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.
 
C

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???
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top