Hi, Kindly need your help..!! I have several .xl files in folders and Sub folders, but file naming is done as Part Number_Part Name. I want to create hyperlink for all the files based on the part name I enter in Sheet 1 of new workbook.