View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
bleucube bleucube is offline
external usenet poster
 
Posts: 1
Default 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'm not sure how to make it
flow. Any VBA magicians out there that can help solve my riddle?

Thanks!