open word from access 2007 using a macro

[DianaH]

On a form, I had a button to open a word document in access 2003.
The macro attached to the button ran RUNAPP

I changed the folder to office12 from office11 - but it still does not work.

Help!

 

[Steve Schapel]

Diana,

I gather you mean you have a macro in your Access 2007 database, using
the RunApp action, but when the button is clicked , nothing at all
happens (is that what you mean by "does not work"?)

Can you please post back with the exact entry in the Command Line
argument of the RunApp action in your macro?

 

[DianaH]

Here is my statement for the Runapp:
c:\Program Files\Microsoft Office\Office12\winword.exe H:\CDP\test.doc
I hope this helps
Thank you
Diana

 

[Steve Schapel]

Diana,

Please try with ""s around the 2 sections of the Command Line, i.e.
"C:\Program Files\Microsoft Office\Office12\winword.exe" "H:\CDP\test.doc"

 

[DianaH]

Steve
This did not work. The macro still opens a blank word document.
Thanks
Diana

 

[DianaH]

Steve
I also put the server path in trust center location

 

[DianaH]

Steve - I FOUND IT!!!!!!!!!!!!!!!!!
I was using the wrong extension. the word document in 2007 is .docx
Thank you for your help
Diana

 

[Steve Schapel]

Wonderful news, Diana. So glad to hear it's sorted now.