Macro to run without spreadsheet being open

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?
 
G

Gord Dibben

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
 
Top