Path to Word in Macro?

[Harmannus]

Hallo,

I use a "macro" to start a Word dot (to merge customers adrresses).

In the RunApp line:

C:\Program Files\Microsoft Office\Office10\Winword.exe
e:\documents\dbContacts.dot

On some systems Office recides in a different directory. How can i make the
above *flexibel*? Meaning that it will start Word no mater in which
directory the exe is...

Thanx for any tips!

Regards,

Harmannus

 

[Douglas J. Steele]

You could try using the ShellExecute API call. It will start any registered
file extension with its default application.

See http://www.mvps.org/access/api/api0018.htm at "The Access Web" for
sample code.

 

[Harmannus]

Hallo,

Thanx for the reply,

How do i start this code from the RunApp line in my macro?

?fHandleFile("e:\documents\dbOfferte.dot", Win_NORMAL) doesn't work ore
other variations a tried...


Regards,

Harmannus

 

[Douglas J. Steele]

What you're trying works fine for me. What happens when you try: do you get
an error?

 

[Harmannus]

Hallo,

A get a macro action halted pop-up

It shows the RunApp line with the code
?fHandleFile("e:\documents\dbOfferte.dot", Win_NORMAL)

Any suggestion to what is wrong?

Regards,

Harmannus

 

[Douglas J. Steele]

You don't include the question mark in your macro.

It's in the sample code because that's what you'd have to type if you were
testing from the Debug window.