You can do wonders with Microsoft Word using your excel, like creating a new word file, open an existing word file, saving it to specific location in your hard drive, print the word document, Add tables to your word document and many more.
Since its and external application, to deal with it first step would be get the instance of the word file or you can say create the Object of the word file using CreateObject Function.
Set objWord = CreateObject("Word.Application")
And that’s it Now you are all set to perform various operations.
In next few sessions you will see the following operations on Word using Excel.
Read more