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.
|