start word 2000 with a macro 2

[munger]

One command button is supposed to open word 2000. There I have a macro which is supposed to open. The Word 2000 Help says to open like this: winword.exe/mmacroname . I can't get that to work. What I am doing wrong?

Michael Unger

 

[sheronne]

I don't quite understand. You have a command button on an access form which you want to activate Word2000. Is this correct. If so

Choose RunApp as the Macro action and enter the following as the command line:

"C:\Program Files\Microsoft Office\Office\Winword.exe"

Then Place a button on the form that executes the macro. This will start Word from access.

If this is not it, please explain more in detail.

Later

R

 

[munger]

Sorry! The macro is NOT an access macro. Those I do all the time. I have a WORD macro that goes to a table and sets up the data in a certain way. I want to press the access command button to start word with its macro. But word starts without its macro so I am asking how does one make word begin by processing a macro?

Thank you.

 

[JaSintoHenriqueSido]

Private Sub Comando202_Click()
On Error GoTo Err_Comando202_Click
Dim objword As Object
Set objword = CreateObject("word.Application&quot
With objword
.Visible = True
.Documents.Open ("d:\pasta\pauloaccess.doc&quot

 

[Biglop]

You may need to put a space in:

Like this "winword.exe /mmacroname"