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?

save workbook as current date using a macro
 

You can use the OnTime method to see if the time has passed midnight and
perform an autosave when the condition is met.
--
http://HelpExcel.com
1-888-INGENIO
1-888-464-3646
x0197758


"ExcelJon" wrote:

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?

save workbook as current date using a macro
 

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

ExcelJon wrote:

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?

--

Dave Peterson