How do I activate a workbook (which is already open within the current application) for which I know part of the name? Like, I know that the workbook starts with: CMVINXBXINNNI_Index_MorningReport-
but the rest of the name is unknown (or will vary).
How come I can not reference this workbook in the following manner:
Windows("CMVINXBXINNNI" & "*").Activate
Hope you can help :)