Web Development

General discussion


Word from Access

By john_wills ·
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

.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 conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Comments

Collapse -

by JackOfAllTech In reply to Word from Access

Go to M$ site and search for AUTO97.HLP. It explains all the automation stuff for Office 97, almost all of which still applies no matter what version you have.


Collapse -

by john_wills In reply to

Someone outside TechRepublic had already shown me a practical way to do what I needed to do, but this document seems very valuable.

Collapse -

by john_wills In reply to Word from Access

This question was closed by the author

Related Discussions

Related Forums