File associations

[Leo Scott]

I need to be able to use VBA to open a file with whatever program Windows
(all versions since Win95) has associated with the file extension, just like
double-clicking on the file in windows explorer. This will be done in
Access 2000 VBA. The file names and paths are stored in the mdb. Right now
the file types are just tiff files but they could be pdfs, jpegs, etc.

 

[Allen Browne]

ShellExecute should do the trick.

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