Be the first user to complete this post
|
Add to List |
VBA-Excel: Open word document using GetObject()
Open word document using GetObject(), you need to follow the steps below:
- Get the reference to existing word file using GetObject
- Get the object of Microsoft Word application object
- Make the MS Word visible
Get the reference to existing word file using GetObject
Set objDoc = GetObject ("D:\OpenMe.docx")
Get the object of Microsoft Word application object
Set objWord = objDoc.Application
Make the MS Word visible
objWord.Visible = True
Function FnOpenWordDoc() Set objDoc = GetObject ("D:\OpenMe.docx") Set objWord = objDoc.Application objWord.Visible = True End Function
Also Read:
- VBA-Excel: Consolidator – Merge or Combine Multiple Excel Files Into One
- VBA-Excel: Add/Insert multiple Images/Pictures from a folder in Word Document
- VBA-Excel: Read Data from XML File
- Excel-VBA : Send Mail with Embedded Image in message body From MS Outlook using Excel.
- VBA-Excel: Find a word in a specific paragraph and change its formatting