VBA check if full or partial name exists in folder

[Holyfix]

Hey everyone,
I am struggling with VBA code. I have a folder with pdf files. Every file contains one or more documents. These pdf files are named accordignly to the documents inside so I may have PDF file named 8947 (one document inside) or 8468 7638 7364 (three documents inside). Also, I have an Excel sheet with column containing these numbers and i need to check if every number (PDF file) exists in the folder or not. Is there a way to write VBA code which gives me YES or NO next to these numbers in Excel ?

Thank you very much

 

[Holyfix]

So I have tried to delete "ThisWorkbook.Path" from this part of the code "Set FolDir = FSO.GetFolder(ThisWorkbook.Path & "\Datafiles2")" and it seems to be working.

 

[JEC]

Have you tried the Dir method, earlier suggested?

 

[Holyfix]

I did, but it is says "Bad file name or number". I am still learning in this field so I kind of have no idea what is going on.

 

[NdNoviceHlp]

You can just directly specify the folder path...

Set FolDir = FSO.GetFolder("C:\YourFolderName")

Dave

 

[Holyfix]

That is what I did. Thank you again for your help

 

[NdNoviceHlp]

You are again welcome. Dave