how to save spreadsheet at a specific time automatically
 

I have an excel spreadsheet with real time data feed. How can I let excel
automatically save the file as a different file at some specific time, say
12:00PM every day? Or will macro do the job? What is a good way/ easy way to
implement it?

Thanks for your thoughts.

how to save spreadsheet at a specific time automatically
 

Take a look in VBA Help for Application.OnTime.

how to save spreadsheet at a specific time automatically
 

Hi Sean,

See Chip Pearson's OnTime page at:

http://www.cpearson.com/excel/ontime.htm


---
Regards,
Norman


"Sean" wrote in message
...
I have an excel spreadsheet with real time data feed. How can I let excel
automatically save the file as a different file at some specific time, say
12:00PM every day? Or will macro do the job? What is a good way/ easy way
to
implement it?

Thanks for your thoughts.

how to save spreadsheet at a specific time automatically
 

Thanks. Norman and Jackey. That helps.

"Norman Jones" wrote:

Hi Sean,

See Chip Pearson's OnTime page at:

http://www.cpearson.com/excel/ontime.htm


---
Regards,
Norman


"Sean" wrote in message
...
I have an excel spreadsheet with real time data feed. How can I let excel
automatically save the file as a different file at some specific time, say
12:00PM every day? Or will macro do the job? What is a good way/ easy way
to
implement it?

Thanks for your thoughts.