How to open another program and file?

[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

 

[JLGWhiz]

The program would have to support VBA to be able to issue commands to the
application.

 

[smartin]

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

Have you tried something like this (in VBA)?

Shell "C:\Program Files\IrfanView\i_view32.exe C:\Images\MyPic.jpg"

 

[Tim Williams]

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

 

[Mel]

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