How to: Activate Workbooks
Some code examples in this topic use the this or Me keyword or the
Themethod of the collection activates a Microsoft Office Excel 2003 workbook and selects the first sheet in the workbook.
To activate a workbook
Use the Activate method of the Workbooks collection.
If you want to activate the workbook associated with the project, you can use the
To activate the workbook associated with the project
Activate the workbook using
You can index into the Workbooks collection using either integers (indicating the position within the collection) or workbook names. If you want to refer to a workbook by name, however, you must be careful how you refer to it: you must use the name you see in the title bar, which does not include the ".xls" extension until you save the file.
To reference individual workbooks
Use the position number or the name of the workbook.