specified time / copy worksheet + save

R

Robert B.

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

Robert B.

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

Frederik

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