We help IT Professionals succeed at work.

Controlling a Word document that is already open from Access VBA

Medium Priority
549 Views
Last Modified: 2012-05-06
I want to do things to a Word document that is already open. However, I can't seem to be able to get an object to that document in Access VBA. How do I do it?
Comment
Watch Question

Commented:
Dim app As Word.Application



Sub test1()

Set app = GetObject(, "Word.Application")
MsgBox app.ActiveDocument.FullName
End Sub
Commented:
or by name

app.Documents("doc1.doc").PrintPreview

Not the solution you were looking for? Getting a personalized solution is easy.

Ask the Experts

Author

Commented:
Thanks, I did ask for code to return an object, but that was easy enough. The issue was that I had more than one document open, so needed to specify the one I wanted. I was trying to use a full path, but only the name (as you showed) is needed.
Access more of Experts Exchange with a free account
Thanks for using Experts Exchange.

Create a free account to continue.

Limited access with a free account allows you to:

  • View three pieces of content (articles, solutions, posts, and videos)
  • Ask the experts questions (counted toward content limit)
  • Customize your dashboard and profile

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.