Locating winword.exe for RunApp Macro

[Bevo]

I have a RunApp macro to open a word document as a mail merge (example
"c:\program files\microsoft office\office10\winword.exe" "c:\my
documents\test1.doc"). The problem I'm having is that people are running the
database at various locations, office, laptop, home or flash drive. The
macros will not work because it can't find winword.exe. For some computers
it's located in microsoft office\office or microsoft office\office10 or
microsoft office\office11. Is there a code I can add or change that will
locate winword.exe wherever it is located?

 

[Douglas J. Steele]

I think you'll find it much easier to use the FollowHyperlink method in VBA
(Application.FollowHyperlink "c:\my documents\test1.doc"), or else use the
ShellExecute API (see http://www.mvps.org/access/api/api0018.htm at "The
Access Web" for a complete sample)