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

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

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

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

 

To Format already written text in a word document – Format All Content 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
  • Create a Selection object with the help of WordObject.
  • Select the Whole content in the word document
  • Do the formatting
  • Save the word document
  • Close the word document

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

VBA-Excel: Open and Print the Word Document

To open an existing Microsoft Word Document  and print it 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
  • Print the word document
  • Close the word document

 

Create the object of Microsoft Word

Set objWord = CreateObject(“Word.Application”)

Read moreVBA-Excel: Open and Print the Word Document

VBA-Excel: Add/Insert multiple Images/Pictures from a folder in Word Document

To Add or Insert Multiple Images or Pictures in Microsoft Word Document using Microsoft Excel, you need to follow the steps below:

  • Declare END_OF_STORY and MOVE_SELECTION as variables
  • Assign MOVE_SELECTION =0 and END_OF_STORY = 6
  • Create the object of Microsoft Word
  • Create the object of FileSystemObject
  • Create Folder object using FileSystemObject and GetFolder method
  • Using MS word object, Open the existing word document by providing the complete path
  • Make the MS Word visible
  • Create a Selection object with the help of WordObject.
  • Access Folder files using Folder object
  • Get the image paths from the folder
  • Insert image in the word documents using AddPicture()
  • Insert a page break after every image

Read moreVBA-Excel: Add/Insert multiple Images/Pictures from a folder in Word Document

VBA-Excel: Add/Insert a Image/Picture in Word Document

To Add or Insert Images or Pictures in Microsoft Word Document using Microsoft Excel, you need to follow the steps below:

  • Create the object of Microsoft Word
  • Using MS word object, Open the existing word document by providing the complete path
  • Make the MS Word visible
  • Create a Selection object with the help of WordObject.
  • Set  Shapes object using InlineShapes
  • Insert image in the word documents using AddPicture()

 

Create the object of Microsoft Word

Set objWord = CreateObject(“Word.Application”)

Read moreVBA-Excel: Add/Insert a Image/Picture in Word Document

VBA-Excel: Appending Text to an Existing Word Document – at the End

To append the text at the end of the Microsoft Word Document using Microsoft Excel, you need to follow the steps below:

  • Declare END_OF_STORY and MOVE_SELECTION as variables
  • Assign MOVE_SELECTION =0 and END_OF_STORY = 6
  • Create the object of Microsoft Word
  • Using MS word object, Open the existing word document by providing the complete path
  • Make the MS Word visible
  • Create a Selection object with the help of WordObject.
  • Move the Selection to the end of the document.
  • Append the text in  the Word Document using SelectionObject

Read moreVBA-Excel: Appending Text to an Existing Word Document – at the End