Once I set it like this, how can I stop the macro if I need to look at the
workbook?
--
Thank you!


"Gord Dibben" wrote:

Use Task Scheduler to start Excel and open the workbook every day at a
designated time.

You will have workbook_open code which fetches the data then saves and
closes the workbook then shuts down Excel.

Like 4:30AM when no one will be around and using Excel.


Gord Dibben MS Excel MVP


On Mon, 24 May 2010 11:18:04 -0700, Doug
wrote:

Is there a way to do it with the workbook closed? I would rather not even
open the workbook unless I find that there is something wrong with the data
that I pull from it in another workbook.

.