I have used this for a long time from a MENU sheet to goto a filename typed
in a cell or to a sheet in the menu file. I have it so that it will
activate if already open.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"JLatham" wrote in message
...
Very nice, I like that and hadn't even thought about such a method.

If the OP then formatted column A as underlined blue text, they'd even
look
like hyperlinks.

"Don Guillett" wrote:

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

.