View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
ExcelJon
 
Posts: n/a
Default save workbook as current date using a macro

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?