| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Issuing macro in workbook from separate workbook | Excel Discussion (Misc queries) | |||
| Extracting data from the current date | Excel Worksheet Functions | |||
| bringing data from one workbook to another using a date stamp func | Excel Worksheet Functions | |||
| how to alter the date within a macro | Excel Discussion (Misc queries) | |||
| i made change in a current workbook and accidentally save it, can. | Excel Discussion (Misc queries) | |||
Hybrid Mode
