VBA-Excel: Change Font, Color, Weight of Table Data in the Word document

To Change Font, Color, Weight of Table Data in the Word document using Microsoft Excel, you need to follow the steps below (First we will create a table and while filling the data we change the font, color and weight of data):

  • 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 (Here we will insert some code to make changes in data)
  • Save the document

Read moreVBA-Excel: Change Font, Color, Weight of Table Data in the Word document

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