|
-
Mar 31st, 2008, 04:13 PM
#1
Thread Starter
Hyperactive Member
refer to this workbook w/ variable ?
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|