Open a Word Document from Excel

Add to Favorites
This Microsoft Excel macro will open a Microsoft Word document from excel. With this macro, you can open any word document on your computer. This is a small but cool macro; you can attach it to a button or checkbox and then, whenever a user clicks the button or checkbox, have a specified Microsoft word document open.

You can change the word document that will open by changing this line of code objWord.Documents.Open "C:\test.doc" so that the directory and file name, including extension, point to the desired file on your computer.

Where to install the macro:  Module

Open a Word Document from Excel

Sub Open_Word_Document()

'Opens a Word Document from Excel

Dim objWord As Object

Set objWord = CreateObject("Word.Application")
objWord.Visible = True

'Change the directory path and file name to the location
'of your document

objWord.Documents.Open "C:\test.doc"

End Sub






Similar Content on TeachExcel
Open a PowerPoint Presentation from Excel
Macro: This free macro for Microsoft Excel allows you to open any PowerPoint presentation fro...
Send Emails through Outlook using Email Addresses from Excel and text from Word
Macro: This macro allows you to send an email to a list of recipients through excel. The email wi...
Delete a VBA Module From Excel
Macro: Delete a VBA macro module from Excel with this macro. This macro allows you to fully ...
Open PDF from Excel
Tutorial: How to open a PDF file from a clickable button, link, or image in Excel.  This allows yo...
Open Microsoft Word from Excel
Macro: This free macro will open the Microsoft Word program on your computer. You do need to have...
Remove Personal Information from Excel Files
Tutorial: How to remove all personally identifiable information from an Excel file. When a file is...



How to Install the Macro
  1. Select and copy the text from within the grey box above.

  2. Open the Microsoft Excel file in which you would like the Macro to function.

  3. Press "Alt + F11" - This will open the Visual Basic Editor - Works for all Excel Versions.  Or For other ways to get there, Click Here.

  4. On the new window that opens up, go to the left side where the vertical pane is located. Locate your Excel file; it will be called VBAProject (YOUR FILE'S NAME HERE) and click this.

  5. If the Macro goes in a Module, Click Here, otherwise continue to Step 8.

  6. If the Macro goes in the Workbook or ThisWorkbook, Click Here, otherwise continue to Step 8.

  7. If the Macro goes in the Worksheet Code, Click Here, otherwise continue to Step 8.

  8. Close the Microsoft Visual Basic Editor window and save the Excel file. When you close the Visual Basic Editor window, the regular Excel window will not close.

  9. You are now ready to run the macro.


Similar Content
Open a PowerPoint Presentation from Excel
Macro: This free macro for Microsoft Excel allows you to open any PowerPoint presentation fro...
Send Emails through Outlook using Email Addresses from Excel and text from Word
Macro: This macro allows you to send an email to a list of recipients through excel. The email wi...
Delete a VBA Module From Excel
Macro: Delete a VBA macro module from Excel with this macro. This macro allows you to fully ...
Excel Forum