Code to run a Macro on a specific day of the week at a specific time.

I have this File that pulls from our WMS system has a sheet for each day of the week. I'd like to automatically run the same code on all 6 sheets at a specific time each day, 08:00, and the save it over the existing file. I'm fortunate enough to have my own desk, so I can leave this open. Basically I want this to run all 6 days if i have a vacation. Once I understand this I'm sure i will be able to use it in many other files.

Receiving Summary LOADED Multiple days.xlsm

The ReceivingSummary macro is the only one I need ran. Here is an scenerio of where i need help on this. I leave work on a Saturday, I leave this file open and it automatically will run the macro and activate the page that corrispondes with the current day of the week. So it will run on Sunday and activate the Sunday page, and then Monday and activate the Monday page.

Originally Posted by venkat1926

it is not cler which macro(s) are to be run at 8 am. if all the mcros are to be run in wich order. why do the macros are placd in different modules why not in one module. the sceleton of running the macro is givne below
if all the mcros are to be run in some orderr then have a new macro with name for e.g. "cominedmacaro"

Please Login or Register  to view this content.

Please Login or Register  to view this content.