ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Have Excel 2007. I would like to have a spreadsheet perform thefollowing simple? tasks (https://www.excelbanter.com/excel-programming/445851-have-excel-2007-i-would-like-have-spreadsheet-perform-thefollowing-simple-tasks.html)

bleucube

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!


All times are GMT +1. The time now is 08:17 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com