Dave Peterson wrote in message Maybe you can record a macro when you import the data and build your graphs.

Then name that macro auto_open.

That macro will start whenever that file is opened (if macros are enabled).

Make sure you continue through saving the new workbook. End your macro with:

...
Application.quit
end sub

(closing all the other workbooks that you may have opened, too.)

Then use Windows Scheduler to start this excel workbook.


that's excellent dave - thanks.

one question ...

presumably this is a every-time hit though... ie when the s/s is
opened several days later it will read in the datafiles again? Thing
is the datafiles change on a daily basis BUT the s/s will be needed
for posterity for a partciular day

i.e. 1st december s/s will use the datafiles created on 1st december,
2nd december s/s uses datafiles created on 2nd december etc... but if
the 1st december s/s is subsequently opened on the 2nd it will
presumably be overwritten by the 2nd december's datafiles ?

which leads me to... can a macro as a grand finale delete itself? ie
open s/s on december 1, macro auto starts and loads the datafiles
(available for december 1st) - then deletes the macro ie itself.

???

ian