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

Excel-VBA : Open a MS Word Document using Excel File using Explorer Window.

This tutorial will teach you how to Open a MS Word Document using Excel File using Explorer Window. We will be using Application.GetOpenFile() function to accomplish this.

NOTE: You can define any type file you want to , just set the proper filter.

FileFilter:=”Word Files *.doc* (*.doc*) – to open Excel files.

Complete Code:

Read moreExcel-VBA : Open a MS Word Document using Excel File using Explorer Window.

VBA-Excel – Merger – Merge or Combine Many Word Documents Into One

Download Link:WordMerger

If you want to combine or merger many word document into one file and you don’t want to do it manually, This piece of software will allow you merge as many word document you want, say 500-1000 word documents. This tool will provide you to option to select ot de-select word documents before merging.

How to Use it:

  1. Down­load the WordMerger.xlsm from the link pro­vided at the top and at the bot­tom of this article.
  2. Place all the Word documents, which you want to com­bine, into one folder (make sure all files are closed).

Read moreVBA-Excel – Merger – Merge or Combine Many Word Documents Into One

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

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

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 moreVBA-Excel: Add Table and fill data to the Word document

VBA-Excel: Open word document using GetObject()

Open word document using GetObject(), you need to follow the steps below:

  • Get the reference to existing word file using GetObject
  • Get the object of Microsoft Word application object
  • Make the MS Word visible

Get the reference to existing word file using GetObject

Set objDoc = GetObject (“D:\OpenMe.docx”)

Get the object of Microsoft Word application object

Set objWord = objDoc.Application

Read moreVBA-Excel: Open word document using GetObject()

VBA-Excel: Enumerate all the opened word document

To enumerate all the already opened Microsoft Word Document using Microsoft Excel, you need to follow the steps below:

  • Create the object of Microsoft Word application object
  • Make the MS Word visible
  • Print all the word doc’s name and path

Create the object of Microsoft Word application object

Set objWord = GetObject(,”Word.Application“)

Make the MS Word visible

objWord.Visible = True

Read moreVBA-Excel: Enumerate all the opened word document

VBA-Excel: Get the Instance of already opened word document

For getting the instance of already opened Microsoft Word Document using Microsoft Excel, you need to follow the steps below:

  • Create the object of Microsoft Word application object
  • Make the MS Word visible
  • Check the name of currently open word doc

Create the object of Microsoft Word application object

Set objWord = GetObject(,”Word.Application“)

Make the MS Word visible

Read moreVBA-Excel: Get the Instance of already opened word document

VBA-Excel: Working with Bookmarks- Insert text After Bookmark

For inserting the text after 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 after the bookmark
  • Save the word document
  • Close the word document

Read moreVBA-Excel: Working with Bookmarks- Insert text After Bookmark

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

VBA-Excel: Appending Text to Existing Word Document – at Beginning

To append the text at the beginning of the already existing 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.
  • Append the text in  the Word Document using SelectionObject

 

Create the object of Microsoft Word

Set objWord = CreateObject(“Word.Application”)

Read moreVBA-Excel: Appending Text to Existing Word Document – at Beginning

VBA-Excel: Edit And Save an Existing Word Document

VBA-Excel: Save an Existing Word Document

To Edit and save an existing 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.
  • Edit the Word Document using SelectionObject
  • Save the Word Document

Read moreVBA-Excel: Edit And Save an Existing Word Document

VBA-Excel: Create and Save the Word document

For creating and saving the Microsoft 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 Selection object with the help of WordObject.
  • Use this Selection object to type the text into the WordDocument.
  • Save the document

 

Read moreVBA-Excel: Create and Save the Word document