Is it possible to write a batch file to open an Excel 2003 sheet with a macro

[pedro-egoli]

Am having difficulty writing a batch file around the following
TYPE
Microsoft Office Excel 2007 Macro-Enabled Workbook
LOCATION
C:\Users\Peter\Documents\AllData\PVOutput files\Pvoutput solar alinta estimates
FILE NAME
7XX ROI sheet FOR BILL starting 090318.xlsm”

This is what I wrote

Start /D "C:\Program files\Microsoft office\office\excel.exe\Users\Peter\Documents\AllData\PVOutput files\Pvoutput solar alinta estimates\7XX ROI sheet FOR BILL starting  090318.xlsm”

It worked the first time I clicked on the bat file located at "C:\Users\Peter\Desktop" under the name Alinta test 2.bat

However, the next time I tried it no luck just a momentaropening and closing of batch file.

Any assistance appreciated

Pedro

 

[Ruddles]

A batch file, as in "runs in a DOS window" type of batch file?

This works for me:-

call "C:\Program Files (x86)\Microsoft Office\Office12\excel.exe" "c:\temp\testfile.xlsm"

 

[pedro-egoli]

A batch file, as in "runs in a DOS window" type of batch file?

This works for me:-

call "C:\Program Files (x86)\Microsoft Office\Office12\excel.exe" "c:\temp\testfile.xlsm"

Thanks Ruddles.
Got it to work using this

start /D "C:\Program Files (x86)\Excel Launcher" /B "Excel Launcher.exe" "C:\Users\Peter\Desktop\Alinta estimated bill.xlsm"

Your assistance appreciated

Pedro