Mega Code Archive

 

Categories / VisualBasic Script / Excel

 

Use a String rather than an index value to reference a workbook

Sub workbookSelectName()     Workbooks("MyWorkbook.xls").Activate End Sub