Excel Open a Word Doc

I need to know how to get Excel to open a word document...

Basically When Excel opens I nedd to have word open also and load a certain Document. I know i could Dim X as Object then set object = ("Word.application") etc...but is there a way to load the document right then?

Thanks!

Try this:

Code:

---

Private Sub Workbook_Open()
    Dim objWord As Word.Application
    Set objWord = New Word.Application
   
    With objWord
        .Documents.Open "C:\MyDoc.doc"
        .Visible = True
    End With
End Sub

---

Hope this helps

and don't forget to register the Word Object libarary in the references!!!

and don't eat with your mouth open....

Thant work....Thanks