search a pdf automatically

[danbitton]

Hello, I have a file on my computer that contains a lot of pdf.
Each pdf is called by the name of a person, then a month, then a year.
I have an excel table that has in colomne first name, name, month, year, then pdf.
I would like to write the name of a person, one year, one month, that a link to his pdf file is automatically displayed in the next celule.
I don’t know how to code.
Thanks to everyone who will help me

 

[Sahak]

Hi Danbitton,

I didn't understand exactly what you need, but this may help?

 

[danbitton]

this is the idea but the pdf are on my desktop, and when I apply this solution, excel does not recognize the pdf

 

[Sahak]

I'm sorry, I still don't understand exactly what you need to be done, can you explain with example?

 

[danbitton]

pdf files are all on the desktop at the following url: C: Users dan9b Desktop .
I would like that according to the name, prenom, me and year, the fifth column acffiche directly for example C: Users dan9b Desktop Danbibi_Sep2020,
C: Users dan9b Desktop RafaNadal_Oct2021
as a pdf link

 

[Sahak]

I'm sorry