Dear VBA express Members,
I have and excel file includes records which in column H as range H1 = 360001 H2 = 360002 H3 = 360003 ETC
I asked my clients to save a document in shared folder names with what mentioned above, as a copy of invoice for 360001 named 360001 and the same with the rest
all what i need to make the VBA give me a file path if it found the invoice in the folder.
the result should be shown in column I as a path and if i clicked it opens the invoice copy.
invoices come with extension PDF or tif
N.B the data numbers of invoices are variable which change every day so i need to check that i have a copy for each invoice and can review it.
many thanks.ISSUE.jpg