Windows 7 - Reference workbook with a certain word in the name

Asked By KeriM on 13-Aug-12 09:47 AM
I need to reference an open workbook in my code but the name changes
periodically; however, it always has the word "count" in it. Is there a
way to reference a workbook by a certain word in the name? This is what
I have so far:


Dim ws As Workbook
If ws.Name Like "*count*" Then ws.Activate


I think I need a "set" somewhere, but I am not sure what to "set" it as.

Any help is appreciated. Thanks!