How to reference open workbook that ends with EFTY

[stephme55]

Hello. I will run code that opens 4 workbooks. How can I run code on specific workbooks only based on ending characters?

For example:

Workbooks("1234567EFTY").Sheets("Sheet1").Copy _

just reference based on EFTY. Thanks.

[Winon]

Hello stephme55,

I believe it would depend on a few qualifications, for instance, are all the Workbooks in the same Folder/Directory, and will the last characters of said Workbooks only contain unique 4 trailing characters?

Regards.

[stephme55]

Yes they are all in same folder. No, in this case it will be EFTY, FA, REMIT, and RMT. But I want to activate a specific workbook based on it's ending characters (this might be the better question). So if I do a loop through all workbooks, to open them all. I can then reference the specific one that I want with the last letters (because the initial numbers will vary).

[Winon]

Hi stephme55,

Thank you for the feedback, and clarification. It helps a lot.

Unlike some Forum Members who may have a ready answer, I would need some time to test a possible working solution.

I shall get back to you as soon as I can.

Regards.