Open A Workbook Each Day

[rockyw]

Is there a way to have an Excel 2010 workbook to open and save and close each day by its self? Thanks

 

[GR00007]

You could use task scheduler (PC or server) to open it at a set time - then have the spreadsheet auto-run with a close at the end.

 

[Joe4]

For what purpose?
What is it supposed to do?

Conceivably, you could add Workbook_Open VBA code that automatically runs when a workbook opens. You could put the save/close code in there (along with anything else that you might want to happen).
Then, you could use a Scheduler to open the file every day. So then it would open, do its stuff, and save/close.
You just need to make sure that the Scheduled job is on a computer that is on every day when it is supposed to run.

 

[rockyw]

There is data that updates when the workbook opens. A code runs and makes changes but if it does not open everyday some data is lost.

 

[Joe4]

OK. The methods proposed should do what you want.