Automatic Actions Based off Computer Time Stamp

Is there a way to code a macro to automatically do something based off the computers date/time stamp. Right now I have macro button that copies sheets clears data, renames sheets but to make it work I have to click the button. I am wondering if I can code it to run base on the computer date and time stamp so every sunday morning it runs? We never shut the computer off and excel is always running. Does anything know if this would be possible?

I am just learning VBA and of course pushing the limits I'm sure.

Thanks.

Heres some code on timer... kinda advanced tho.

http://stackoverflow.com/questions/1...m-in-excel-vba

Ranman,
Thanks, Now I can follow it, but can you explain it at all? I put the macro program, or the events I want to run in the area Sub OnTimer()
And basically this is always running in the background counting up by 1 second until a time is achieved. But what triggers it to run? It looks like nextTriggerTime, but not sure what it matches up against and where that variable is set.

Any ideas.

If you can answer those few things I think that would be everything I needed. Thanks again.

Sorry if these seem basic. I am still learning this stuff, all self taught from trial and error.

Hi veedubnut115,

See the attached file which is a comprehensive scheduler, which you may be able to use with your application.

Please Login or Register  to view this content.

Lewis