Check workbook name for specific word

[rjplante]

I am looking for a way to see if the workbook name contains the word "Template". If so, I want the macro to prompt the user to save the file. I have the code listed below, but it does not seem to give the correct response. How do I get this to work?

If ThisWorkbook.Name = "*Template*" Then
    MsgBox "The workbook does NOT contain the word Template in the name."
     Exit sub
Else
    MsgBox "The workbook DOES contain the word Template in the name."
    Call Save_This_File


End If

Thanks for the support.

 

[Fluff]

Try

If ThisWorkbook.Name Like "*Template*" Then

 

[rjplante]

Awesome!! Thanks Fluff for the quick response. Very simple code fix. Works great!

 

[Fluff]

You're welcome & thanks for the feedback