View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Rob Bovey Rob Bovey is offline
external usenet poster
 
Posts: 811
Default Schedule a Macro

"macroplay" wrote in message
...
Can the windows task scheduler be setup to open an excel workbook and run
a
specific macro. I know I could use auto_open but I've found this
problematic
since there is no way to stop the auto_open code from running so if
there's a
bug it's impossible to fix (pressing shift while opening the file doesn;t
work).


I've used Auto_Open macros for as long as they've been around, and
holding down the Shift key while opening the workbook always stops them from
running. Are you sure you aren't confusing this with the Workbook_Open
event, which does not get stopped by the Shift key?

--
Rob Bovey, Excel MVP
Application Professionals
http://www.appspro.com/

* Take your Excel development skills to the next level.
* Professional Excel Development
http://www.appspro.com/Books/Books.htm