Opening Different Types of Files

[akphidelt]

Hello again, I have run in to another problem. I now can save documents,
whether its excel, pdf, word, etc in to a common folder. But now I want to
set up a listbox where they can double click on the item they want and it
automatically opens up the file.

Is there anyway to do this with a hyperlink or something like that...
because I don't want to create different instances for each type of file that
can be clicked.

Any help would be greatly appreciated... thanks!

 

[Stuart McCall]

Hello again, I have run in to another problem. I now can save documents,
whether its excel, pdf, word, etc in to a common folder. But now I want to
set up a listbox where they can double click on the item they want and it
automatically opens up the file.

Is there anyway to do this with a hyperlink or something like that...
because I don't want to create different instances for each type of file
that
can be clicked.

Any help would be greatly appreciated... thanks!

Check out the FollowHyperlink method of the Application object.

 

[Daniel Pineault]

as Stuart mentioned, Application.FollowHyperlink is typically the solution to
such a question.

Application.FollowHyperlink "c:\temp\test.xls"

Another use tidbit of code for such a situation can be found at
http://www.pacificdb.com.au/MVP/Code/ExeFile.htm it allows you to either open
or print any file.