Excel - Have Excel 2007. I would like to have a spreadsheet perform thefollowing simple? tasks

* At 6:30 AM run a Macro
* At 6:31 AM run another Marco
* After 6:31 Macro is done running, Save the Worksheet as xxxx.
YYYYMMDDhhmmss
* After the worksheet saves, I want cell C2 to list Date and time of
last saved.

I think I have most of the code already, you can view it here
http://pastebin.com/uB86rJAP.

Right now its all separate components. I am not sure how to make it
flow. Any VBA magicians out there that can help solve my riddle?

Thanks!

Hi,

1=B0 create 2 workbooks (as you do not specify if it should be the same work=
book your macros are in) with a vba workbook event open sub workbook_open .=
.. call sub_name end sub and another workbook_save event, with saveas metho=
d and get the current time (for there I am not sure how to do this, the most=
effective way for this might be the windows dll timer class...i'm not sure=
, check-it or if you really need this, I can look for you... and same for C=
2 (all should be done using available vba code...)

2=B0 use windows scheduler, add a schedule event for 6:30 and 6:31 (that wi=
ll for the 2 workbooks you have created earlier) ;

I think this is broadly it

Pascal Baro
http://multiskills.elementfx.com/