Posted to microsoft.public.excel.programming

Max

external usenet poster

Posts: 9,221

Automate simple process to run at 8 am daily

I've got an excel file which will remain open in a PC which is left on 24x7.
At say, 8:00 am daily, I need a sub to copy a sheet: Live (codename), then
insert a new sheet, do a paste special as values & formats, then rename the
new sheet as the date in ddmmm format, eg: 31Dec, and move this to be the
leftmost sheet. Then to save the file. Thanks

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
way to automate this process	rodchar	Excel Discussion (Misc queries)	4	June 26th 09 06:52 PM
Macro to automate process	Journey	Excel Discussion (Misc queries)	0	June 13th 08 02:53 PM
Sub to automate process	Max	Excel Programming	4	October 12th 07 03:03 PM
need to automate process	sand	Excel Discussion (Misc queries)	3	August 3rd 07 06:20 PM
Automate an Excel process	msnate	Excel Programming	1	July 23rd 06 12:46 PM

All times are GMT +1. The time now is 05:39 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us