I am close - not quite there.
I plan to use XP Task Scheduler to open Workbook1 - with auto_open macro the auto_open macro has the refresh workbook command
I am thinking not test yet -
auto_open macro will execute another macro that will delete auto_open macro and save the workbook as Workbook2 and close the Excel Application.
Then my Outlook scheduler will open Workbook2 and email to the distribution list.
Would this be possible?
Thx
Russ
Bookmarks