starting macros via scheduled tasks

  • Thread starter Thread starter mnichols
  • Start date Start date
M

mnichols

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
 
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
 
Back
Top