load Excel file

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

  • load Excel file

    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
    Last edited by Randy P; 02-16-2007, 12:04 PM.

  • #2
    Can you pass the filename? If not you could automate it.
    <internet bumper sticker goes here>

    Comment


    • #3
      Originally posted by craiger_ny View Post
      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?
      Links to my utilities for PCDMIS

      Comment


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

        Comment


        • #5
          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.
          <internet bumper sticker goes here>

          Comment


          • #6
            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.
            sigpic
            if you had soap on a rope it would be tied to yer ankle

            Comment


            • #7
              This command also works

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

              Comment


              • #8
                Originally posted by Randy P View Post
                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...
                Links to my utilities for PCDMIS

                Comment

                Related Topics

                Collapse

                Working...
                X