View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Fred[_16_] Fred[_16_] is offline
external usenet poster
 
Posts: 2
Default 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