save workbook as current date using a macro

[Guest]

Hi,
I have a Workbook who logs a production line with data collected over a OPC
connection.
This workbooks logs equipment stops as well as weight controls.
The workbook is saved every time a new event is registered.

At midnight, i want to autosave the workbook so it's name is the current date.

Anyone that can help me?

 

[Guest]

You can use the OnTime method to see if the time has passed midnight and
perform an autosave when the condition is met.

 

[Dave Peterson]

Chip Pearson has lots of instructions at:
http://www.cpearson.com/excel/ontime.htm