Running a procedure based on time

Hi

How do you run a procedure that activates at a set time?
I want to run a procedure that moves a log file to an archive directory at midnight (or at anytime after this when the PC is next turned on).
Thanks for any help...
Mat

write a batch file or .vbs script that moves the file then schedule it to run in the windows scheduler.

Sorry, perhaps I was not too clear. I want to do this using VBA. I have an Access DB that retrieves data from a log file. I want to move the old one each night at midnight (or next time the database is started if later, or it is not turned on at midnight). This file will go into an archive directory. The code then kills the old log file and re-creates a new one. As the database will be sent to other users - who will not be too PC literate, I need this to be automated - and not done using a Schedule in Xp itself.

Any help would be appreciated ...
Thanks

There is probably a way for you to create a schedule job from your code. That's what Norton Antivirus does for scheduling scans and updates.

Otherwise you need to write your own scheduling service that will do the tasks for you.