Instead of the overhead of hyperlinks try this
Right click sheet tabview codeinsert thismodify your path to suit
Then, assuming you have
myfile typed in a cell and you double click on it the file in yourfolder
will open

Private Sub Worksheet_BeforeDoubleClick _
(ByVal Target As Range, Cancel As Boolean)
ActiveWorkbook.FollowHyperlink Address:= _
"\yourfoldernamehere\" & Target.Value & ".pdf"
End Sub

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

<COOLGUY_IVRCL wrote in message
...
I have around 150000 PDF files to hyperlink in excel from a folder. I have
put the file name in Column A. The file names of PDF file are same as in
Column A. Is there any function or macro which can hyperlink the files.

Can any one help me out of this problem.
--
COOLGUY_IVRCL