Range.Text

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

by

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 more

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

by

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 more