specified time / copy worksheet + save

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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