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: 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

VBA-Excel: Writing Text to Word document

For writing text in Microsoft Word Document using Microsoft Excel, you need to follow the steps below:

  • Create the object of Microsoft Word
  • Add documents to the Word
  • 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.

Read moreVBA-Excel: Writing Text to Word document

VBA-Excel: Open an Existing Word Document

To open 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 the object of Microsoft Word

Set objWord = CreateObject(“Word.Application”)

Read moreVBA-Excel: Open an Existing Word Document

VBA-Excel: Working with Microsoft Word

You can do wonders with Microsoft Word using your excel, like creating a new word file, open an existing word file, saving it to specific location in your hard drive, print the word document, Add tables to your word document and many more.

Since its and external application, to deal with it first step would be get the instance of the word file or you can say create the Object of the word file using CreateObject Function.

Set objWord = CreateObject("Word.Application")

And that’s it Now you are all set to perform various operations.

In next few sessions you will see the following operations on Word using Excel.

Read moreVBA-Excel: Working with Microsoft Word