Macro to run without spreadsheet being open

  • Thread starter Thread starter Dan Wood
  • Start date Start date
D

Dan Wood

Is there a way to et a macro to run without the sheet being open? Within my
macro there is a timer of 00:00:01 to run he macro, but this will only work
with the spreadsheet open.

Is there a way to run the macro overnight without the sheet being open?
 
Macros cannot be run without opening the workbook.

You could use Windows Task Scheduler to start Excel, open the workbook and
run the macro.

Add code to close the workbook and quit Excel when done.


Gord Dibben MS Excel MVP
 
Back
Top