hyperlink duplicates items and print out through folders and subfolders

[Hasson]

Hi

I have invoices numbers in column H in sheet1 , some of them will repeat the same number and the invoices are existed within folder and subfolder in this directory "C:\Users\DANI\\Desktop\REPORTS\"

the files are PDF . so what I want macro to hyperlink the invoice numbers in column H and when click the cell contains invoice number then should open the file and show message if I want print out the file or not .
thank you

 

[Hasson]

the message show by the EXCEL program , not by your code .
it informs me if I want to open or not.