Opening Excel

[thenettrainer]

Hello all. OK, using 4.1 . . .

Can a specific file be opened using the Ext command?

I open Excel with no problem from within the CMM program.

EXTERNALCOMMAND/DISPLAY ; C:\PROGRAM FILES\MICROSOFT OFFICE\OFFICE11\EXCEL.EXE

But I need a specific file to open that has a VB script to pull the data from the CMM program after it runs.

I tried using the path to where the file is. No can do.

EXTERNALCOMMAND/DISPLAY ; C:\Documents and Settings\wknazek\Desktop\Excel Files\name of file here

I know. My "file" isn't an exe. Excel is. But my Excel file contains an exe. Does that count? LOL )

[Don Ruggieri]

batch file

try creating a batch file that contains nothing more than the path/name of the spreadsheet. Then call the batch file from the external command

[James Doolittle]

Not the prettiest solution in the world, but you can create an .exe program, where all it does is opens a specific excel file...

[bobcavallo]

Program is the same as your example, but add the filename to the end of the command line.

EXTERNALCOMMAND/DISPLAY ; C:\PROGRAM FILES\MICROSOFT OFFICE\OFFICE11\EXCEL.EXE c:\files\filename.xls

[James Doolittle]

booya. Bob's got it.