Check if a filename contains (not equals) the value of a cell

Hi! Sorry if my formatting is incorrect, I haven't posted here before.

Edit: I am very new to VBA, by the way!

I have a column of part numbers and I'm working on filling out columns of info about that part. Some of this info comes from SolidWorks drawings which are contained in a .dwg file.

This is the code I found to check if the file exists that equals the cell value.

Please Login or Register  to view this content.

If I have "Hello" in a cell, and "Hello.txt" on my desktop, it returns Yes which is great; however, the .dwg files would probably show up like "3123Hello3295889.dwg," which, obviously, returns no. Is there any way to check if a filename CONTAINS the cell value instead?