need to hyperlink to 100 files in the excel sheet

  • Thread starter Thread starter anil
  • Start date Start date
A

anil

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
 
If the filenames are in A1:A100, you can use something like this in B1:

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

hyperlink some 10 sheets in a workbook 2
i need to find the exact location of macro to paste in the existing macro need to get the out put co 0
Need a Macro to combine 1-5 sheets in one sheet 1
Need a macro to combine the data from sheets 3
counting numbers 3
Hyperlink Help 4
autocad Hyper links 3
automatically folder create 1

Back
Top