Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Open a file - Application unknown
I want to be able to open a file without stating the application to
open it. Not unlike adding a hyperlink to a cell value. Only, I want it done in VBA since it must take some variables. The following works great if the path to the application is known. Dim x As Variant x = Shell( AppPath & " " & FilePath, 1) However, i want it to take the windows default application to open the file. Again, much like the result a hyperlink produces. Simply omitting the AppPath results in an Error 5, something like "invalid procedure call or invalid argument". |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Open a file - Application unknown
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
opening a file in Excel starts application but dose not open file | Excel Discussion (Misc queries) | |||
Open unknown file name | Excel Programming | |||
How do I start a new application when I open a file? | Excel Discussion (Misc queries) | |||
Can Excel open a new application every time you open a file? | Setting up and Configuration of Excel | |||
Open file with unknown extra characters at end of filename | Excel Programming |