Timed Macros

[s_white1]

I currently have a DB that obtains its data from an Excel file. I have constructed a macro that when operated deletes existing datasheets and imports the new Excel data. It then constructs the new datasheets for Access.
I currently have this macro operated via a command button on my main form. However I wish for this macro to operate at midnight everyday. I have tried placing it in the 'onchange' event procedure for a text box containing '=date()', this however failed to work.
Any Suggestions?

 

[s_white1]

Thanks Pat, could you possibly enlighten me on 'scheduling programs'.

 

[sunilvedula]

Hi Pat,

Would you be able to share with us hwo this batch runs and what the code is if feasible. i too am stuck with similar kind of problem.