View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Doug Doug is offline
external usenet poster
 
Posts: 460
Default What is correct syntax when using Scheduled Tasks?

I want to set up a scheduled task to open Excel and run a macro. What is the
correct syntax for requesting that? The macro is stored in my Personal Macro
workbook. I am currently using as my run command in Scheduled Tasks
(C:\.....Excel 2003.lnk" PERSONAL.xls!ESB_Load). When I run the task I get an
error message saying PERSONAL.xls!ESB_Load could not be found. How do I
specify the macro (ESB_Load) that is stored within the PERSONAL.xls workbook?