View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Frank Kabel Frank Kabel is offline
external usenet poster
 
Posts: 3,885
Default 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/

.