VBA Nightly Process Run

[Gian624]

I have an excel spreasheet where I would like to run a Ctrl+Shift+R in three seperate tabs at 9:00 PM every night. Does anyone know if that is possible? I am not a VBA user by rights so if you have a solution, please treat me as a novice.

Thank you Kindly,
Matt

 

[Joe4]

CTRL-SHIFT-R is probably a custom shortcut to a Macro (VBA Code). If you go to the Run Macros window, you should be able to figure out what one that is.
Once you determine that macro name, you can call it and run it form a Workbook_Open event (see: Excel VBA Events - Easy Excel Macros).
If you select the sheet you want to run it against, then call that Macro, it will run upon opening the worksheet. You can repeat for the other two sheets too.

If you want to run it at a specific time every night, I would use Windows Scheduler to open that file at the time you want every night. Just add code at the end of your Workbook_Open event to close it when done.