macro to rename the workbook that has been created in the same macro

Hi all
Hope you had a nice weekend! Here is the description of the problem that I`m currently struggling with:

I have a given macro that at some point creates a new workbook, and in later steps it activates this newly created workbook several times - so the name `book1` appears several times in this macro. The problem is that in some cases (e.g. when you want to use this macro more than once) this newly created workbook is not called `book1`, but `book2`, `book3`etc. - it makes the macro does not work properly. That is why I want to rename the workbook right after creating it, but without saving on the disk. Is that possible? If not, is there any other way to deal with that, e.g. change the code in order to activate the workbook that has been recently created, but keeping in mind that other workbook is being activated as well?

Thanks in advance for your help.

here is the sample of the code (in a sample workbook) - I don`t know if it works or not, but this gives you the flavour of the issue.

hm, this should be fine, but in my macro the following error is being shown:
`object doesn`t support this property or method`

and then the first line of TheNewWB.Select instead of Book1.Activate is being highlighted. What`s the reason for that? I`ve put

Please Login or Register  to view this content.

at the very beginning of my macro, right after the name.

I also should have noticed the difference between select and activate
thank you Trevor