need to hyperlink to 100 files in the excel sheet
 

hi all,

I have included 100 file names from a folder in an excel sheet, i need
to give hyperlink for all the files,

Please help me with a macro.

Thanks & Regards
Anil Hungund

need to hyperlink to 100 files in the excel sheet
 

If the filenames are in A1:A100, you can use something like this in B1:

=hyperlink("File:////" & a1,"Clickme!")
and drag down.

anil wrote:

hi all,

I have included 100 file names from a folder in an excel sheet, i need
to give hyperlink for all the files,

Please help me with a macro.

Thanks & Regards
Anil Hungund

--

Dave Peterson