Activate Workbook and Worksheet with Wildcard
Posted on 2011-09-30
I need to activate a workbook and worksheet that will already be open. I have code that works for this for the specific name, but the date at the beginning will change every month, so I want code that will use a wildcard for the date and select the workbook and worksheet for activation just using the last part of the name.
This is what works now:
This is the basic idea of what I would like to work: