Auto Run Macro

[MOHE92]

Hello All,

Was wondering if it is possible to automatically run a macro on a schedule?

I needed to run a simple macro every Saturday @ 11:30PM

Any help would be appreciated.

Thanks

Mo

[teylyn]

Yes, but the workbook would have to be open, so the macro can fire. You could open a workbook via Windows scheduler and have a macro automatically run with the Workbook_Open event, or use

Please Login or Register  to view this content.

[MOHE92]

Thanks for the reply...

Right now I am using this code, however, I need it only to run on Saturdays.

And my workbook is always open....

[teylyn]

you could do the Application.OnTime for the set time, but before you branch off into your code, check if the current date's weekday is a Saturday.

here's some code to find out today's weekday as a number, i.e. 4 is Wednesday

Please Login or Register  to view this content.