automatic running of macros

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a database for my business that imports the previous day's
information. This is done with a macro. My question is, is there any way to
have the macro run automaticly durning off hours? Idealy I would like it to
run at midnight and be all done by the time I get into the office in the
morning.
Thanks!
DS
 
DS,

Probably the best approach is to use Windows Task Manager, or some other
scheduling software (for example I have found
http://www.splinterware.com/products/wincron.htm very good), to handle
this by defining an event scheduled to run at midnight. The syntax for
the Command Line for the scheduler to run, will be something like this...

"C:\PathToAccess\Msaccess.exe" "C:\PathToDb\YourDb.mdb" /x NameOfMacro
 
Back
Top