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:


Code:
--------------------

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!




--
KeriM