Help with inserting ActiveWorkbook.Name Like in correct place

[shrubfact]

Hi

The files I want to open will be named "Example" but will also have a number attached which will differ every week eg. Example 01, Example 02 and so on.
If the correct files "Example" are not selected then I don't want the macro to run and alert that incorrect file has been selected.
I'm trying to use the following code within my current macro to do this

I'm having trouble inserting it in the right place as it either will not open any files at all, or it doesn't run the macro when not "Example" (which I want) but still opens the incorrect file that is selected (which I don't want).

Any help as to where to insert the code please

Macro example below

Any help appreciated

[TMS]

If you've already got the file name from the filtered list, why don't you test it before you open it.

Or, maybe you could add "example" to the filter.

[mehmetcik]

If left(ActiveWorkbook.Name,9) = " Example " Then

Else


EndIf

[shrubfact]

Thanks for your help

I've got a mental block as I cant get either working now, so annoying I was so close earlier now no where near