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/
.