Show Buttons
Share On Facebook
Share On Twitter
Share On Google Plus
Share On Linkdin
Share On Reddit
Contact us
Hide Buttons

VBA-Excel: Working with Microsoft Word

You can do won­ders with Microsoft Word using your excel, like cre­at­ing a new word file, open an exist­ing word file, sav­ing it to spe­cific loca­tion in your hard drive, print the word doc­u­ment, Add tables to your word doc­u­ment and many more.

Since its and exter­nal appli­ca­tion, to deal with it first step would be get the instance of the word file or you can say cre­ate the Object of the word file using Cre­ateOb­ject Function.

Set objWord = CreateObject("Word.Application")

And that’s it Now you are all set to per­form var­i­ous operations.

In next few ses­sions you will see the fol­low­ing oper­a­tions on Word using Excel.

  1. Cre­ate a new Word Document
  2. Open an Exist­ing Word Document
  3. Writ­ing Text in Word Document
  4. Cre­ate and save the word document
  5. Edit and Save an exist­ing word document
  6. Append­ing Text to Word Doc­u­ment at Beginning
  7. Append­ing Text to an Exist­ing Word Doc­u­ment — at the End
  8. Add/Insert a Image/Picture in Word Document
  9. Add/Insert mul­ti­ple Images/Pictures from a folder in Word Document
  10. Open and Print the Word Document
  11. For­mat already writ­ten text in a word doc­u­ment – For­mat Paragraphs
  12. For­mat already writ­ten text in a word doc­u­ment – For­mat All Content
  13. Find a word in a spe­cific para­graph and change its formatting
  14. Work­ing with Book­marks– Insert text After Bookmark
  15. Work­ing with Book­marks– Insert text Before Bookmark
  16. Get the Instance of already opened word document
  17. Enu­mer­ate all the opened word document
  18. Add Table and fill data to the Word document
  19. For­mat the Exist­ing Table in a Word document

Happy Macro­ing :)

Sumit Jain


You may also like...

Leave a Reply

Your email address will not be published. Required fields are marked *

%d bloggers like this: