Paragraphs.Count

VBA-Excel: Find a word in a specific paragraph and change its formatting

by

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: Format already written text in a word document – Format Paragraphs

by

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 more