Is it possible to use wildcard in VBA?

Hi all,

I have a Workbook_Open code, which I would like to "Knock Out" with the following line sometimes...

Please Login or Register  to view this content.

but obviously the file name has a date in it which changes..

Is it possible to do a wildcard thing to ovecome this?

(Its part of a big project, involving a save as - under a different name and stripping the sheets the Workbook_Open refers to, hence the KO line)

Thanks!

Like operator with wildcard.
e.g

Please Login or Register  to view this content.

# represents numeric character 0-9.

Oh Magic! Thank you very much

You are welcome and thank for the rep.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

Same question different syntax, is it possible to use the Wildcard in this code somehow?

Please Login or Register  to view this content.

After copying the tables (from an original one that I also keep) to different sheets the numbers appear behind the table names... how can I use wildcard instead of the actual numbers?

No there are more tables.

You need to loop to find the name like

Please Login or Register  to view this content.

Thank you that worked!