Macro to run at specified time

S

Steve

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

Steve Schapel

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