Another Excel / Word Question....

[Static]

Now...Is there a way to "SetFocus" to the Word window?
(I know I can use AppActivate..) But I want to Be able to Switch to WOrd without having to give the Title in Appactivate.

(Because sometimes it has the word (copy) on the end of the title...and I need to pull it up either way)
Thanks

[Gaffer]

Use objWord.Activate

i.e.

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

Some advice: When you type the ".", it will give you a list of possible events, methods, and constants you can use. The only way of finding this stuff out is by trying a few that look like they may do the job.

Good luck!

[Static]

.Activate
Cool.

Thanks