Need Macro for giving hyperlink

[Palanik]

HI friends,

I need a macro that shall be used to give hyper link after selecting the folder.

eg.

I have a folder : NameRecord
This folder contains pdf name : Vinay, Vijay........


Excel sheet - I have the below details in columnA (serial No), columnB (Name).

Vinay
Vijay
Ajith
Sathyan


I need a macro to give hyperlink automatically after selecting the folder.
The hyperlink should be given to each name...When I select a name the respective PDF file should open...

Is this possible?

Can any give me the macro...Please help me.

Thanks in advance