! Call Procedures in Word !

W

Wembly

Hi,

Is it possible to call procedures in Word from Access?

E.g. Word doc has a public procedure that performs letter
merge. Can I call this procedure from an Access cmdButton,
rather than getting the user to click on a button in Word
to activate the code?

I already have code that opens the doc template, and I
want to append the above code after the code that opens
the DOT.

Thanks

Wembly
 
D

Dev Ashish

Is it possible to call procedures in Word from Access?
Click to expand...

Use Application.Run method.

in doc2.doc

Public Sub Foo()
Msgbox "In Foo"
End Sub

In Access,

Dim w As Word.Application

Set w = New Word.Application
With w
.Visible = True
.Documents.Open CurrentProject.Path & "\Doc2.doc"
Call .Application.Run("Foo")
End With

-- Dev
 
Top