A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

open word from access 2007 using a macro



 
 
Thread Tools Display Modes
  #1  
Old May 5th, 2008, 06:23 PM posted to microsoft.public.access.forms
DianaH[_2_]
external usenet poster
 
Posts: 6
Default 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  
Old May 5th, 2008, 08:28 PM posted to microsoft.public.access.forms
Steve Schapel
external usenet poster
 
Posts: 1,422
Default 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  
Old May 5th, 2008, 08:47 PM posted to microsoft.public.access.forms
DianaH[_2_]
external usenet poster
 
Posts: 6
Default 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  
Old May 5th, 2008, 09:04 PM posted to microsoft.public.access.forms
Steve Schapel
external usenet poster
 
Posts: 1,422
Default 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  
Old May 6th, 2008, 01:55 PM posted to microsoft.public.access.forms
DianaH[_2_]
external usenet poster
 
Posts: 6
Default 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  
Old May 6th, 2008, 02:01 PM posted to microsoft.public.access.forms
DianaH[_2_]
external usenet poster
 
Posts: 6
Default 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  
Old May 6th, 2008, 02:26 PM posted to microsoft.public.access.forms
DianaH[_2_]
external usenet poster
 
Posts: 6
Default 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  
Old May 6th, 2008, 09:40 PM posted to microsoft.public.access.forms
Steve Schapel
external usenet poster
 
Posts: 1,422
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 08:50 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.