How do I set a macro to run every 24 hours

  • Thread starter Thread starter Michael
  • Start date Start date
M

Michael

I need to set a macro to run at a set time every day. I am using a database
to collect information from an external source. I am not at this computer
every day, and the information that I am retrieving is deleted every day. If
I don't get the information, it is lost. Is it possible to write a code to
make the macro run at a set time every day?
 
Use the Scheduling tool that's built into Windows, and pass it a command
line along the lines of:

"C:\Program Files\Office\msaccess.exe" "C:\Data\MyDatabase.mdb" /x MyMacro
 
Michael said:
I need to set a macro to run at a set time every day. I am using a
database
to collect information from an external source. I am not at this computer
every day, and the information that I am retrieving is deleted every day.
If
I don't get the information, it is lost. Is it possible to write a code
to
make the macro run at a set time every day?
Click to expand...

I explain a possible solution here:

http://www.members.shaw.ca/AlbertKallal//BatchJobs/Index.html
 
Back
Top