ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   What is correct syntax when using Scheduled Tasks? (https://www.excelbanter.com/excel-discussion-misc-queries/223600-what-correct-syntax-when-using-scheduled-tasks.html)

Doug

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?


All times are GMT +1. The time now is 04:37 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com