How to open another program and file?

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
 
J

JLGWhiz

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

smartin

Mel said:
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"
 
T

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
 
M

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top