What is correct syntax when using Scheduled Tasks?

D

Doug

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need Help with Macro Security 1
Need some PWA help 0
Menu Macro Not Executing - Need Help 1
Avoiding Leads, using SVT, and Linking Tasks correctly 0
Personal.xls workbook duplicated 1
Personal.xls will not open when I open excel 2
Trying to run a MSQuery from Excel as a Scheduled Task 1
Macro Will Not Save 2

Top