Opening Excel

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Opening Excel

    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 )

  • #2
    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

    Comment


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

      Comment


      • #4
        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

        Comment


        • #5
          booya. Bob's got it.

          Comment

          Related Topics

          Collapse

          Working...
          X