RunApp Path

[Greg Jackson]

I am using Access 2002 and trying to open a file in MS
Word with the following in the command line:

"C:\Program Files\Microsoft Office\Office10
\WINWORD.EXE": "C:\Temp\cve.txt"

This works great...However, WINWORD.EXE is not located in
the same directory on all machines. Is there a way to
prompt the user for the full path to WINWORD.EXE, assign
that to a variable, and use the variable in the command
line above. For example:

MyPath: "C:\Temp\cve.txt"

Thanks in advance!

 

[Nikos Yannacopoulos]

Greg,

You needn't worry about the path. Office installation adds the Office path
to the Path statement loaded at Windows startup, so Windows knows where to
find it. That is to say,

"WINWORD.EXE": "C:\Temp\cve.txt"

should work on any machine.

HTH,
Nikos