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?

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?

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