Need VBA help to refresh and save worksheet.
April 22, 2012 12:37 PM Subscribe
Have Excel 2007. I would like to have a spreadsheet perform the following simple? tasks
posted by bleucube to Computers & Internet (3 answers total) 1 user marked this as a favorite
* 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 in pastebin
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?