How to open another program and file?
 

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

How to open another program and file?
 

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


"Mel" wrote in message
...
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

How to open another program and file?
 

Mel wrote:
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"

How to open another program and file?
 

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" wrote in message
...
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

How to open another program and file?
 

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

On Oct 8, 10:56*pm, "Tim Williams" wrote:
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" wrote in message

...

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