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: Find a word in a specific paragraph and change its formatting

To Find a word in a specific paragraph and change its formatting in an existing Microsoft Word Document using Microsoft Excel, you need to follow the steps below: 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 … Read more VBA-Excel: Find a word in a specific paragraph and change its formatting

VBA-Excel: Format already written text in a word document – Format Paragraphs

To Format already written text in a word document – Format Paragraphs  – Microsoft Word Document using Microsoft Excel, you need to follow the steps below:

  • 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 paragraphs count
  • Get the paragraph object using Paragraphs.Range
  • Do the formatting
  • Save the word document
  • Close the word document

Read moreVBA-Excel: Format already written text in a word document – Format Paragraphs