How to open another program and file?

  • Thread starter Thread starter Mel
  • Start date Start date
M

Mel

Excel 2003

Is there a way to make a macro open a specific file within a specific
program, or to launch a specific program and then open a specific file
in it?

The file:
C:\Images\MyPic.jpg

The program:
C:\Program Files\IrfanView\i_view32.exe

(It doesn't work to just open the jpg file using a simple link because
Excel by design opens jpg's in Internet Explorer, not the associated
program, and I don't want it opening in IE.)

Thanks,
Melina
 
The program would have to support VBA to be able to issue commands to the
application.
 
Look at Shell

Dim RetVal
Dim ProgPath as string
Dim FilePath As String

ProgPath = "C:\Program Files\IrfanView\i_view32.exe"
FilePath = "C:\Images\MyPic.jpg"
RetVal = Shell(ProgPath & " " & Filename, 1)



Tim
 
You guys are so awesome I can't stand it. <g> Thanks, Tim. It worked
perfectly. That was too cool. I will read about Shell on my own now to
find other ways to apply it in my tasks. I love it!

-Melina
 
Back
Top