ExcelBanter - Select Window Containing specific text

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Select Window Containing specific text (https://www.excelbanter.com/excel-programming/395085-select-window-containing-specific-text.html)

stevec

Select Window Containing specific text

I have a line of code that looks like this:

Windows("Bannana -- 2007 07 31.xls").Activate

How do I change this to activiate any workbook that contains the name
"bannana"?

thanks...

All times are GMT +1. The time now is 02:37 PM.