function to launch default app given filename

[goodone]

Hi, All, Access 07 VBA

Is there a function like Shell that will launch default app given file name?
Example: call <function>("c:\xyz.jpg") 'opens PCs default graphics
viewer/editor

Thank you!
Jim
(e-mail address removed)

 

[RoyVidar]

Hi, All, Access 07 VBA

Is there a function like Shell that will launch default app given
file name? Example: call <function>("c:\xyz.jpg") 'opens PCs
default graphics viewer/editor

Thank you!
Jim
(e-mail address removed)

Yes, check out
http://www.mvps.org/access/api/api0018.htm

 

[Douglas J. Steele]

While Roy's answer is a very good way, even simpler would be:

Application.FollowHyperlink "c:\xyz.jpg"

 

[Allen Browne]

Use FollowHyperlink e.g.:
DoCmd.FollowHyperlink("C:\xyz.jpg")

You may get a security warning on that unless you build the hyperlink
correctly, including prepending file:/// For details, see:
Hyperlinks: warnings, special characters, errors
at:
http://allenbrowne.com/func-GoHyperlink.html

If you need something more involved, ShellExecute would do it. Details:
Start an app with ShellExecute
at:
http://www.mvps.org/access/api/api0018.htm