load Excel file

[Randy P]

I want to load Excel at the end of my program and a file called report.xls when excel loads how do I do that? I can get Excel to start with this command.
EXTERNALCOMMAND/DISPLAY ; C:\PROGRAM FILES\MICROSOFT OFFICE\OFFICE\EXCEL.EXE
Now how to automaticaly load the report.xls file

[craiger_ny]

Can you pass the filename? If not you could automate it.

[cmmguy]

Can you pass the filename? If not you could automate it.

You meant add the path and file name to the end of the:
EXTERNALCOMMAND/DISPLAY ; C:\PROGRAM FILES\MICROSOFT OFFICE\OFFICE\EXCEL.EXE

Right?

[Randy P]

I got it may not be the best way but I made a bat file that loads excel and the file. Then use that as an external command.

[craiger_ny]

Yeah, I was wondering if he tried that. I say pass but maybe that is not the right term. I'm not sure if it passes well that way or not but he certainly is not going to break anything trying. If that does not work then automation should suffice.

[T Miller]

I think you could also put a copy of the report.xls file in
Documents settings\admin\application data\microsoft\excel\xlstart
that would open that file Everytime you open excel.

[Randy P]

This command also works

EXTERNALCOMMAND/DISPLAY ; C:\PROGRAM FILES\MICROSOFT OFFICE\OFFICE\EXCEL.EXE c:\pcdmis_Reports\report.xls
Thanks

[cmmguy]

This command also works

EXTERNALCOMMAND/DISPLAY ; C:\PROGRAM FILES\MICROSOFT OFFICE\OFFICE\EXCEL.EXE c:\pcdmis_Reports\report.xls
Thanks

I like your bat file idea.

Advantage: Global change to all programs using it by making one change in the BAT file instead of all of the part programs. ie, report name changes or you use another method to report.

Disadvantage: Cant use the "pause" capability of PCDMIS, but in your case not an issue...