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

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/

.