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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Time dependant Excel Macro 1
Macro Help Required 3
Run a Macro at a certain time 2
Running a macro based on the time 1
Macro for active sheet only 4
Run Macro If Cell have "x" value 0
Macro to run when a particular sheet is opened 4
How do you get a macro to reference the worksheet it is being run 2

Top