Hi,

I know the code ActiveWorkbook.name will give me the name of the file that I am currently working on.

Is there a way to check that the name contains certain string

e.g
I have 4 files
21 Aug Wage.xls
21 AUg Wage_Check.xls
21 Aug Wage_Analysis.xls
21 Aug Wage_total.xls

What I want is to be able to check if the file name is * Wage_Check.xls or * Wage.xls etc.

Can anyone help ?

Brian