Mega Code Archive

 

Categories / VisualBasic Script / Excel

 

To avoid confusion, you can select a workbook unambiguously- if you know the name of the desired Workbook object

Sub activateWorkbookByName()     Workbooks("Book2").Activate End Sub