-
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....
-
Thanks....Perfect