Workbook.UseWildcards (Excel)

True if the workbook enables wildcards for character string comparisons and searching.

Dim booUseWildcards As Boolean
booUseWildcards = ActiveWorkbook.UseWildcards