<div>
Something like this perhaps.<br />
<br />
If ActiveWorkbook.Name Like &quot;*OVD*&quot; Then<br />
&nbsp; &nbsp;MsgBox &quot;The active workbook had OVD in it's name<br />
End If<br />
<br />

</div>


Something like this perhaps.

If ActiveWorkbook.Name Like "*OVD*" Then
   MsgBox "The active workbook had OVD in it's name
End If



<div>
<div class="content wysiwyg-content">
Dear Experts,<br />
<br />
Could you please advise how to write a check in VBA, which would analyse the active workbook name whether the file name contains characters &quot;OVD&quot;?<br />
<br />
So for example if the file name is &quot;OVD_0922.xlsx&quot; in that case the answer is True, if &quot;Book1.xls&quot; in that case False.<br />
<br />
thanks,
</div>
</div>


Dear Experts,

Could you please advise how to write a check in VBA, which would analyse the active workbook name whether the file name contains characters "OVD"?

So for example if the file name is "OVD_0922.xlsx" in that case the answer is True, if "Book1.xls" in that case False.

thanks,

VBA Excel 2010 - ActiveWorkbook.Name

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.