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?

See
http://www.cpearson.com/excel/OnTime.aspx

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Dan Wood" wrote in message ...
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

On Sun, 20 Dec 2009 02:23:01 -0800, Dan Wood
wrote:

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?