Word from Access - TechRepublic
General discussion
August 12, 2003 at 02:45 PM
john_wills

Word from Access

by john_wills . Updated 22 years, 11 months ago

I have constructed a Word file which drags data from an Access table. I now want to open the file from VBA in Access so that the user can print the labels in the Wrod file. I cannot find information on the methods of the Word Application object type. I have been trying to emulate some code which opens an Excel file, but it seems that there is not enough symmetry.
‘ here starts attempt to open a Word file
Dim ReturnAddressFile As Word.Application
Set ReturnAddressFile = CreateObject(“Word.Application”)
With ReturnAddressFile
.Visible = False
.Activate
.

.Open “Labels4”
.Visible = True
End With
Exit Sub
‘ here ends attempt to open a Word file
“Open” is not recognized. What do I need to code?

This discussion is locked

All Comments