Open a word document in excel

  • Thread starter Thread starter Michael
  • Start date Start date
M

Michael

I have Vb running collecting some data in Excel and would
like for it to open a word document after it finish's. Is
there a way to open a word document from within Excel's
Vb.
Michael
 
Try this Michael

Set a reference to the Word ? object library

Sub test()
Dim WordApp As Object
Set WordApp = CreateObject("Word.Application")
WordApp.documents.Open "c:\Data\ron.doc"
WordApp.Visible = True
End Sub
 
Back
Top