» 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