View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
mokshadavid mokshadavid is offline
external usenet poster
 
Posts: 6
Default Open Word Document using VBA in Excel

Thanks, so much for your answer. I used only part of the code. When I
tested all of the code you gave me, it would open up the document and then
close it immediately. Why is this?

Sub OpenWordDocumentFromExcel()
Dim oWord As Object
Set oWord = CreateObject("Word.application")
oWord.Documents.Open "C:\test"
oWord.Visible = True
End Sub