Switch to specific excel window via macro

Technowolf · Sep 3, 2014

Is there a way to switch to a specific excel window via macro?
I know

Code:

  On Error GoTo ChangeWinErr
    Set nw = ActiveWindow.ActivateNext
    If Windows.Count > 1 Then
       nw.Activate
       Exit Sub
    End If

to cycle through excel windows, but is there something like .AppActivate in Excel VBA?

Technowolf · Sep 3, 2014

Yeesh, no reply. Guess not then...

Technowolf · Sep 3, 2014

Figured it out! It's actually pretty easy. To switch to a specific window (assuming this is an already opened window with a file name) it's just:

Code:

Windows("filename.xlsm").Activate

shg · Sep 3, 2014

Code:

    Windows(2).Activate

or

Code:

    Workbooks("Bob.xlsx").Activate