Windows 8.1 Task Scheduler Launch Excel Workbook

[infotechmarketing]

I was using Task Scheduler in Windows 7 to launch a .xlsm workbook that executes macros upon opening. I migrated the program to a computer using Windows 8.1. When Task Scheduler launches, Excel is opened as an application but the specific workbook is not. Does anyone know how to get the specific workbook to open? I've tried to adjust my Trust Center settings to make it easy to open a workbook with macros.

 

[K e v i n]

Hi,
Using the full paths works for me:

Program/script:
"C:\Program Files\Microsoft Office\Office14\Excel.exe"
Add arguments:
C:\Users\kevin\Desktop\Book1.xlsm

Hope that helps

 

[infotechmarketing]

Yes, that works. I also used notepad to just enter the path and name in quotes and then "Exit" on a second line. I saved it as a .bat file. I then used scheduler to launch the .bat file.