Open document using its default application

[Diarmuid]

Hi
I want users to be able to type in a document thats associated with a
employee. For example , a word document or a bitmap. I know the Shell
function lets me run an external app, but I have to specify which one and
know the path of the exe. I want to the do the same as Windows Explorer
does, open the file using the appropiate application - either Word or paint
in the example above.
Thanks
Diarmuid

 

[Allen Browne]

FollowHyperlink might do the trick, but if you need better control of what
happens use ShellExecute.

Details:
http://www.mvps.org/access/api/api0018.htm

 

[Diarmuid]

Thanks.

FollowHyperlink might do the trick, but if you need better control of what
happens use ShellExecute.

Details:
http://www.mvps.org/access/api/api0018.htm

 

[Albert D. Kallal]

Just use:


application.FollowHyperlink "c:\my documents\test.xls"

The above opens any file via the association...and no api..and no funny
stuff....