To open an existing Microsoft Word Document and print it using Microsoft Excel, you need to follow the steps below:
- Create the object of Microsoft Word
- Create Doc object using MS word object, Open the existing word document by providing the complete path
- Make the MS Word visible
- Print the word document
- Close the word document
Create the object of Microsoft Word
Set objWord = CreateObject(“Word.Application”)