| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
starting macros via scheduled tasks
I have an excel spread sheet open 24/7 logging data. Once a day I us
application.OnTime to run a macro. However this VB code is embedde within the excel spread sheet. Is it possible to start the same macro once a day using the window scheduled task as opposed to using any vba code -- Message posted from http://www.ExcelForum.com |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
starting macros via scheduled tasks
Hi
one idea: - put your code in the workbook_open event of your file - open this file with the Windows scheduler - also close the file in the workbook_open event -----Original Message----- I have an excel spread sheet open 24/7 logging data. Once a day I use application.OnTime to run a macro. However this VB code is embedded within the excel spread sheet. Is it possible to start the same macro once a day using the windows scheduled task as opposed to using any vba code? --- Message posted from http://www.ExcelForum.com/ . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Windows Scheduled Tasks | Excel Discussion (Misc queries) | |||
| how many people are scheduled between... | Excel Worksheet Functions | |||
| What is correct syntax when using Scheduled Tasks? | Excel Discussion (Misc queries) | |||
| Scheduled Task | Excel Programming | |||
| Starting a userform upon starting the file | Excel Programming | |||
Linear Mode
