save workbook as current date using a macro

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

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?
 
You can use the OnTime method to see if the time has passed midnight and
perform an autosave when the condition is met.
 
Back
Top