Hello,
I run a ton of macro via the Windows Scheduler. I created a batch file that triggers (/x) the macro and set the scheduler to run it whenever I want.
Here is a basic Article from Microsoft
http://support.microsoft.com/kb/230575/
This is an example of the batch file I use: w/ Office 2003, my file name Myissue.mdb and my macro “Import Daily csv”
--------------------------------------------------
C:
CD\Program Files\Microsoft Office 2003\OFFICE11
Start Msaccess.exe C:\MYISSUEDB.mdb /x Import Daily csv
(optional lines, See Below)
PING localhost -n 20 >nul
taskkill /im MSACCESS.exe /f
---------------------------------------------------
The last two lines you probably don’t need. I use those to wait 20 seconds (while the macro runs) and close Access.
I run a bunch of macros this way if I didn’t do that part I would have a bunch of instances of the same file open at a time.
Anyway type the code into notepad save it as a .bat file and use the Windows Scheduler and you should be fine.
--Boxcar