Macro: Search for a file name in a specified folder and link to excel cell

Hi!

I need a macro to read the contents (policy number) in a cell (A2), then search for a file name in a certain folder that starts with the contents of that cell then link that file to other cells (B2,C2,D2) and repeat the process down the column.

I have no idea how to search for a file name using excel, so any help would be amazing. Thanks!


Ex. Book1.xlsx

So I started writing something...

Please Login or Register  to view this content.

I'm using windows 7, and I *THINK* I just need something to actually search a specified PDF folder... I just have no idea how to do that. Seriously, any help would be AMAZING. Even if it was just a hint at a place to look for ideas. I'm so lost/stuck/frustrated. I really don't care about linking anything. Just finding the darn files.

I really don't get how vba works (kinda just learned as i went along for the past two weeks or so), and I kinda just made up that code with NO IDEA what it means

They are all in the same folder.. the path name is basically J:\COMPANYBLAH\Reinsurance\Claims\YEAR\CLIENT\Proofs\

Do you know how to edit that so it would look for a file name that started with a certain number and was in pdf format? and is it possible when entering the folder location to stop after the folder "Claims", so the search looks in all years and all client folders?

Thanks very much