Vba code to search folders to find cell value and create hyperlink

Hi All

I have a worksheet(attached).
Column B is a long list of different invoice no's....eg TT CCM 001
I am looking for VBA code to search through my directory and find a pdf file i.e TT CCM 001.pdf and create a hyperlink.
The problem however is that the Dir has numerous different folders with the pdf's within. So TT CCM 001.pdf is in subfolder Circus Circus
and all the other pdf's are within there own client subfolder.

The code must go down the list i.e B4:B141 , search for the corresponding cellvalue pdf and create the hyperlink.

Any help will be appreciated. I have searched but have not found any coding to assist.

My Dir is "C:\Users\Steven\Desktop\EZ Stock\Clients"

Thank you in advance

Hi JBeaucaire

Fantastic you are a star

Hello im new to the VBA macro.

This code is what im search both one litle thing. I wont in the hyperlink phat is \\192.168.150.6\My Scans\12345.pdf and noth C:\Users\Martin\My Scans\12345.pdf it this posible.

Best Regrads

Yes. I must only change #topPATH = "C:\Users\Martin\My Scans\"# to #topPATH = "\\192.168.150.6\My Scans\\#

THX for help its work.

Hello

Again me whit a new question , in the attached image is how I use the macro , my suggestion is that the hyperlink be created in the row C and the name will be the same as is.

Please Login or Register  to view this content.

Excel_macro.PNG

Sorry for my late replay was out of Town. Yes yours change works perfect.

THX