Tip Printed from ExcelTip.com

---

Launch Word file from Excel VBA


Thanks to Ralph Hernandez from Elk Grove Village, Illinois for submitting the tip


This code will allow you to launch an existing Word file using a command button in Excel.

Private Sub CommandButton1_Click()

Set wrdApp = CreateObject("Word.Application")
Set wrdDoc = wrdApp.Documents.Open("C:FolderLocationFilename.doc")

End Sub