Dilemma of Multiple Apps for SHELL Call

[Alan]

Salutations to the Group!

I would appreciate a best practice recommendation... I've got a distributed
Access 2003 app that has a listbox of document files. The listbox selection
is called with a SHELL command to go to a WORD, EXCEL or ACROBAT document. My
dilemma is how to poll Windows to determine the SHELL command's appropriate
program path for multiple users of the application (Office 10, 11, 12, Vista,
Acrobat 6, 7, 8, 9 etc). Thanks!

Alan

 

[Stefan Hoffmann]

hi Alan,

The listbox selection
is called with a SHELL command to go to a WORD, EXCEL or ACROBAT document. My
dilemma is how to poll Windows to determine the SHELL command's appropriate
program path for multiple users of the application (Office 10, 11, 12, Vista,
Acrobat 6, 7, 8, 9 etc). Thanks!

You don't have to worry about it. The known files are automatically
assigned to the correct application when using the shell execute API call:

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

Simply open/execute the file. It is the same as e.g. executing my.pdf
in a command prompt window.


mfG
--> stefan <--

 

[Alan]

Awesome. Thanks, Stefan.
Alan

hi Alan,

You don't have to worry about it. The known files are automatically
assigned to the correct application when using the shell execute API call:

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

Simply open/execute the file. It is the same as e.g. executing my.pdf
in a command prompt window.


mfG
--> stefan <--