View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Ron de Bruin Ron de Bruin is offline
external usenet poster
 
Posts: 11,123
Default Open a word document in excel

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


--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2000-2003)
www.rondebruin.nl



"Michael" wrote in message ...
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