| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
specified time / copy worksheet + save
Can Excel at a specified time (say 23:59) copy a worksheet and save it? Say
you have three worksheets open (A,B,C) and you want Worksheet C to be copied automatically. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
specified time / copy worksheet + save
Yes, Excel can.
Look in the Help for the Ontime method. "Robert B." schreef in bericht ... Can Excel at a specified time (say 23:59) copy a worksheet and save it? Say you have three worksheets open (A,B,C) and you want Worksheet C to be copied automatically. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
specified time / copy worksheet + save
Mr. Frederik,
I checked the online help for Ontime method. Example - Application.OnTime TimeValue("17:00:00"), "my_Procedure" Where would I put that line? Thanks for your help, Robert B. "Frederik" wrote: Yes, Excel can. Look in the Help for the Ontime method. "Robert B." schreef in bericht ... Can Excel at a specified time (say 23:59) copy a worksheet and save it? Say you have three worksheets open (A,B,C) and you want Worksheet C to be copied automatically. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
specified time / copy worksheet + save
Hello Robert
You have to put that line in a general VBA module. Of course you have to write your own "my_Procedure" that describes what you like to be done. "Robert B." schreef in bericht ... Mr. Frederik, I checked the online help for Ontime method. Example - Application.OnTime TimeValue("17:00:00"), "my_Procedure" Where would I put that line? Thanks for your help, Robert B. "Frederik" wrote: Yes, Excel can. Look in the Help for the Ontime method. "Robert B." schreef in bericht ... Can Excel at a specified time (say 23:59) copy a worksheet and save it? Say you have three worksheets open (A,B,C) and you want Worksheet C to be copied automatically. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I copy formulas but using the same range each time I copy | Excel Worksheet Functions | |||
| 'Save current worksheet'; 'Open next worksheet' - two command buttons | Excel Discussion (Misc queries) | |||
| How to save a file without overwrite or save a copy? | Setting up and Configuration of Excel | |||
| Automatically save a copy of worksheet from C: to Network Drive | Excel Discussion (Misc queries) | |||
| Worksheet Buttons (Save, Save As, Cut, Paste, etc.) Not Working | Excel Worksheet Functions | |||
Linear Mode
