official_raghu
12 years agoOccasional Contributor
Setting MS Word Visible
I am trying to open Microsoft Word application in automation.
Sub OpenWordDoc
Dim objWord, objWordDoc
Set objWord = Sys.OleObjects("Word.Application")
Set objWordDoc = objWord.Documents.Open(C:/ProgramFiles/.../.xyz.docx)
objWord.Visibe = True
End Sub
This of course creates an instance of WINWORD.EXE and opens the xyz.docx file, but it doesn't become maximized (visible on screen). It just sticks to the task bar. I tried many things, like:
objWord.Application.Visible = True
objWord.Application.Activate
objWord.WindowState = 1
objWordDoc.ActiveWindow.Visible = True
objWordDoc.ActiveWindow.Activate
objWordDoc.ActiveWindow.Panes(1).Visible = True
and so on... None seem to work.. Please help. All thanks in advance :)
Sub OpenWordDoc
Dim objWord, objWordDoc
Set objWord = Sys.OleObjects("Word.Application")
Set objWordDoc = objWord.Documents.Open(C:/ProgramFiles/.../.xyz.docx)
objWord.Visibe = True
End Sub
This of course creates an instance of WINWORD.EXE and opens the xyz.docx file, but it doesn't become maximized (visible on screen). It just sticks to the task bar. I tried many things, like:
objWord.Application.Visible = True
objWord.Application.Activate
objWord.WindowState = 1
objWordDoc.ActiveWindow.Visible = True
objWordDoc.ActiveWindow.Activate
objWordDoc.ActiveWindow.Panes(1).Visible = True
and so on... None seem to work.. Please help. All thanks in advance :)