refer to unknown window name

[Guest]

Im writing a code for a workbook which will freqently be copied and renamed.

In part of the code for this workbook it goes outside the workbook and then
has to reselect it

Windows("????????").Activate

How can I get it to know the name of the workbook the code is in?

Thanks,

Ciara

 

[Roman]

Ciao,
try
Thisworkbook.activate

 

[Guest]

but the thing is i go out of the workbook - into another excel file - and
then go back into the orignal one - but i dont' know the originals name!

 

[Roman]

What do you mean by "going out"? If it is just "activate" then
Thisworkbook should be OK.
As I know Thisworkbook means the workbook the code is running from no
matter what and where it is doing.

 

[Guest]

you are absolutely right - sorry got a bit confused - thanks!