Automatic Regular Macro Running

  • Thread starter Thread starter Sue
  • Start date Start date
S

Sue

Hi
Is it possible to have a Macro that runs (importing tables) at a specific
time each day without user input. Also wondered if its possible to use
access to unzip zipped files before importing them.
Cheers
Sue
 
Hi
Is it possible to have a Macro that runs (importing tables) at a specific
time each day without user input. Also wondered if its possible to use
access to unzip zipped files before importing them.
Cheers
Sue
Click to expand...

You can use Windows Scheduler (in Administrative Tools under Start... Control
Panel) to launch Access on a schedule. You can have a macro named, say,
RunStuff in your database, and use a command line switch /x RunStuff in the
command line in Scheduler.

You can (with a bit more effort) have Scheduler execute a .BAT file which
could call WinZip or your favorite zip utility in command line mode, and then
open Access using the /x switch.

John W. Vinson [MVP]
 
Back
Top