Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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" |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
no program registered to open this file | Excel Discussion (Misc queries) | |||
Excel program remains open after closing file | Excel Discussion (Misc queries) | |||
Diff between clicking on a file and using file open w/in program? | Excel Discussion (Misc queries) | |||
how to open a dgx file on excel or another program | Setting up and Configuration of Excel | |||
Open a file o the program that was created | Excel Programming |