Using a date or a time to trigger a macro

[wasmith1963]

Can you use a date or time to trigger a macro? For instance, I want to run a series of make table and update queries every Monday at 8:00 am.

When I set the date/time condition in the macro window (ex. Date() In #2/3/2003#,#2/10/2003# and time()=8:00:00 AM) the RunMacro Command fails to launch the macro(s).

Any suggestions?

Thanks!

 

[johnwm]

Just run your exe from Windows Scheduled tasks is thhe easy way
________________________________________________________________
If you want to get the best response to a question, please check out FAQ222-2244 first

'People who live in windowed environments shouldn't cast pointers.'

 

[wasmith1963]

Hey thanks for the tip. With some massaging of my autoexec macro I have managed to make this work.

Thanks again.

 

[laurabro]

Is there any other way of doing this? - I don't want to run the macro from my scheduler because other people use my database, so I want the macro to run itself from excel on a particular date (and then if for any reason I left, the database would still be workable)