Workbook.Activate (Excel)
Activates the first window associated with the workbook.
This method won't run any Auto_Activate or Auto_Deactivate macros that might be attached to the workbook (use the RunAutoMacros method to run those macros).
Workbooks("BOOK4.XLS").Activate