Macro to run at specified time

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

Guest

How can I write a macro to run at midnight every day and not have the
database open? I would like to export a table/query as a csv file. Is this
possible? If so, can anyone provide the code?
 
Steve,

Use Windows Task Manager, or some third party scheduling utility, to run
the task at the required time. The command line will be something like
this synyax...
"C:\PathToAccess\Msaccess.exe" "C:\PathToDb\YourDb.mdb" /x NameOfMacro

The macro itself will use the TransferText action.
 
Back
Top