Macro to run at specified time

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

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

Similar Threads

How do I set a macro to run every 24 hours 2
Compact & Repair, Open table, close table, then run macro 3
Autoexecut a macro at a specific time 1
automatically trying to run a macro at a certain time 0
Error Message Cannot Update Database is Read Only Error 2950 0
automatically trying to run a macro at a certain time 1
Error When Using TransferText in a Macro 1
How do I automate/schedule an Access macro to run nightly? 1

Top