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


--
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