Activate Workbook
 

I've written some code that will be used in a workbook
template. The code creates a new workbook, does some
stuff to it, closes it, and returns to the template. I
was using the following code:

Windows("Template.xls").Activate

But, I've realized that the users will probably be
changing the name of the workbook. How can I always return
to the workbook in which the macro resides?

Thanks in advance!
Fred

Activate Workbook
 

Fred,

The ThisWorkbook reference will always refer to the workbook
containing the code. So you can write

ThisWorkbook.Activate


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Fred" wrote in message
...
I've written some code that will be used in a workbook
template. The code creates a new workbook, does some
stuff to it, closes it, and returns to the template. I
was using the following code:

Windows("Template.xls").Activate

But, I've realized that the users will probably be
changing the name of the workbook. How can I always return
to the workbook in which the macro resides?

Thanks in advance!
Fred