Why doesn't a wildcard work for a workbook name compare?

[garygomes]

The wildcards does not appear to function in this line of code:

If wbBook.Name = "*FARF*.xlsm" Then

The IF statement never finds a match though I know a workbook with a name containing 'FARF' is open.

[jindon]

= operator doesn't recognise wild cards, so use Like operator.

If wbBook.Name Like "*FARF*.xlsm"

[Leith Ross]

Hello garygomes,

Welcome to the Forum!

In VBA, the wild cards must be used with the LIKE operator. However, the LIKE operator is case sensitive. Your code will work if written as below and the name is in all capitals.

If wbBook.Name Like "*FARF*.xlsm" Then

[garygomes]

you guys rock! Thanks!

[Leith Ross]

Hello garygomes,

You're welcome. Are in the Union City across from the Haystack?

[Cutter]

@garygomes

Based on your last post it seems that you are satisfied with the solution(s) you've received but you haven't marked your thread as SOLVED. I'll do that for you now but please keep in mind for your future threads that Rule #9 requires you to do that yourself.
Thanks.

Also as a new (or relatively new) poster in the forum, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.