Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
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!
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Using a single cmdButton to perform different tasks Roger on Excel Excel Programming 5 December 5th 09 11:34 PM
how can i perform multivariate analysis in excel 2007? ezza59 Excel Worksheet Functions 1 June 2nd 09 07:24 AM
Having links from excel spreadsheet to my outlook tasks soleil Excel Discussion (Misc queries) 1 May 13th 06 12:12 PM
Automation of Excel to perform simple tasks on many workbooks. admin4office Excel Programming 4 February 15th 05 12:49 AM
Can I perform tasks on a closed Workbook Jeff Excel Programming 1 January 27th 05 06:13 PM


All times are GMT +1. The time now is 06:31 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"