VBA-Excel: Format the Existing Table in a Word document

To Format the Existing Table in a Microsoft Word Document using Microsoft Excel, you need to follow the steps below:

  • Create the object of Microsoft Word
  • Open the already existing word document
  • Make the MS Word visible
  • Get the Table object
  • Edit  the data in table
  • Save the document

 

Create the object of Microsoft Word

Set objWord = CreateObject(“Word.Application”)

Read moreVBA-Excel: Format the Existing Table in a Word document

VBA-Excel: Add Table and fill data to the Word document

VBA-Excel: Add Table and fill data to the Word document

To Add Table and fill data to the Word document using Microsoft Excel, you need to follow the steps below:

  • Create the object of Microsoft Word
  • Create a document object and add documents to it
  • Make the MS Word visible
  • Create a Range object.
  • Create Table using Range object and define no of rows and columns.
  • Get the Table object
  • Enable the borders of table using table object.
  • Fill the data in table
  • Save the document

Read moreVBA-Excel: Add Table and fill data to the Word document

VBA-Excel: Working with Bookmarks- Insert text After Bookmark

For inserting the text after the Bookmark in an existing Microsoft Word Document using Microsoft Excel, you need to follow the steps below:

Add a Bookmark “IMBOOKMARK” with name “bookmark_1

  • 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
  • Get the range object for the bookmark
  • Insert the text after the bookmark
  • Save the word document
  • Close the word document

Read moreVBA-Excel: Working with Bookmarks- Insert text After Bookmark

VBA-Excel: Working with Bookmarks- Insert text before Bookmark

For inserting the text before the Bookmark in an existing Microsoft Word Document using Microsoft Excel, you need to follow the steps below:

Add a Bookmark “IMBOOKMARK” with name “bookmark_1”

  • 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
  • Get the range object for the bookmark
  • Insert the text before the bookmark
  • Save the word document
  • Close the word document

Read moreVBA-Excel: Working with Bookmarks- Insert text before Bookmark