Workbooks("NLEAPGIS10.xls").Activate
Workbooks("NLEAPGIS10.xls").Worksheets("nindex").Activate

Instead of doing the above lines, is there a command which returns the name of the workbook instead of having to explicitly call the workbook name?

something like a

Workbooks(this.Workbook).activate ?

thanks much