If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
open word from access 2007 using a macro
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! |
#2
|
|||
|
|||
open word from access 2007 using a macro
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? -- Steve Schapel, Microsoft Access MVP DianaH wrote: 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! |
#3
|
|||
|
|||
open word from access 2007 using a macro
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" wrote: 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? -- Steve Schapel, Microsoft Access MVP DianaH wrote: 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! |
#4
|
|||
|
|||
open word from access 2007 using a macro
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" -- Steve Schapel, Microsoft Access MVP DianaH wrote: Here is my statement for the Runapp: c:\Program Files\Microsoft Office\Office12\winword.exe H:\CDP\test.doc |
#5
|
|||
|
|||
open word from access 2007 using a macro
Steve
This did not work. The macro still opens a blank word document. Thanks Diana "Steve Schapel" wrote: 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" -- Steve Schapel, Microsoft Access MVP DianaH wrote: Here is my statement for the Runapp: c:\Program Files\Microsoft Office\Office12\winword.exe H:\CDP\test.doc |
#6
|
|||
|
|||
open word from access 2007 using a macro
Steve
I also put the server path in trust center location "DianaH" wrote: Steve This did not work. The macro still opens a blank word document. Thanks Diana "Steve Schapel" wrote: 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" -- Steve Schapel, Microsoft Access MVP DianaH wrote: Here is my statement for the Runapp: c:\Program Files\Microsoft Office\Office12\winword.exe H:\CDP\test.doc |
#7
|
|||
|
|||
open word from access 2007 using a macro
Steve - I FOUND IT!!!!!!!!!!!!!!!!!
I was using the wrong extension. the word document in 2007 is .docx Thank you for your help Diana "DianaH" wrote: Steve I also put the server path in trust center location "DianaH" wrote: Steve This did not work. The macro still opens a blank word document. Thanks Diana "Steve Schapel" wrote: 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" -- Steve Schapel, Microsoft Access MVP DianaH wrote: Here is my statement for the Runapp: c:\Program Files\Microsoft Office\Office12\winword.exe H:\CDP\test.doc |
#8
|
|||
|
|||
open word from access 2007 using a macro
Wonderful news, Diana. So glad to hear it's sorted now.
-- Steve Schapel, Microsoft Access MVP DianaH wrote: Steve - I FOUND IT!!!!!!!!!!!!!!!!! I was using the wrong extension. the word document in 2007 is .docx Thank you for your help |
Thread Tools | |
Display Modes | |
|
|