General discussion

Locked

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

3 total posts (Page 1 of 1)  
| 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.

Ralph

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

Back to Web Development Forum
3 total posts (Page 1 of 1)  

Related Discussions

Related Forums