Opening any Document

[Stuart]

Does anyone have any VBA code they could share that opens a document - with
the correct program based on extension - like Windows does? i.e., open a
..DOC with MS Word, open a .pdf with Acrobat, etc.

Thanks, Stuart

 

[Douglas J. Steele]

The FollowHyperlink method should do just that:

Application.FollowHyperlink "full path to file"

Another alternative would be to use the ShellExecute API, as illustrated in
http://www.mvps.org/access/api/api0018.htm at "The Access Web"