Shelling to Application 1

[Larry95]

I'm trying to shell to an application using VBA in Access 2000. The thing is that I don't know what application I'm shelling to, I need to get the associated application for the file the user chooses.

Example
User chooses file e:\notes.txt

My program needs to know that this is a text file and to open it's associated application (notepad).

 

[JoeMiller]

Try out this web page, it has what you're after:

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

HTH Joe Miller
joe.miller@flotech.net