give a different name when adding a new workbook

[Hjahren]

Hi

I have a macro which copies cells, adds a new workbook, and pastes into it.

But when it adds a workbook, it is named iex "Book1". If I have been working in excel it may happen that the book added is called "Book 2, 3, 4 and so on. Which makes it difficult to referr to the book. Is it possible to set the name given as prefix? for example Temporary. Without having the whole save as scenario etc..

[Domski]

Easiest way is to assign the new workbook to a variable that you can then work with without knowing its name:

Please Login or Register  to view this content.

Dom

[Hjahren]

thx

This will work perfect on the first macro which add the workbook.

But i have other macros which will work with the added workbook. How to I solve this problem?

[Domski]

If you declare the variable at a module level all the macros within that module can use it.

Please Login or Register  to view this content.

Alternatively you can pass it between macros as an argument:

Please Login or Register  to view this content.

Dom

[Hjahren]

Thank you!