Adjust code for variable workbook title

[Raphaelp]

I have the following code:

Please Login or Register  to view this content.

The issues are with the workbooks references

Please Login or Register  to view this content.

and

Please Login or Register  to view this content.

. And all subsequent instances of these workbook references.

Sometimes "Book3" is named "Book1", sometimes it is "Book2", etc. The same thing for "CatalogListing-2.xlsx", some times it is "CatalogListing-1.xlsx", sometimes it is "CatalogListing (2).xlsx" etc.

Can someone help me adjust the code so that it would work for "Book*" (wildcard) and for "CatalogListing*.xlsx" (wildcard)?

Thank you!

[Arkadi]

Will this work?

Please Login or Register  to view this content.

[ELeGault]

What is creating Book1, 2 ,3 etc...?

I think we need to see that portion of the code to help you out here.

[TMS]

If Book* is active when the macro is run, then you could use ActiveWorkbook. But I suspect it is not. In which case, you could loop through the open workbooks to find the first workbook that begins with "Book". Or, you could get the macro itself to create a new workbook using Workbooks.Add. This would become the ActiveWorkbook so you could Name it and set a reference to it for later use.

[Arkadi]

My original post probably works, but as others have brought up, the ideal scenario is to work with a workbook object that you can set when the code creates or opens the other books, assuming that is done through code... a more complete code post might help us find the best solution...

[Raphaelp]

How about before the actual code runs an input box will open with "Select the workbooks you will be using"

Is that possible?