Excel Open a Word Doc

[Static]

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!

[Gaffer]

Try this:

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

[Gaffer]

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

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

[Static]

Thant work....Thanks