Automatic hyperlinking

  • Thread starter Thread starter Mon
  • Start date Start date
M

Mon

Hello again:)

I need to hyperlink file names in an excel sheet (in column A) to
audio files bearing the same name. I don't want to do it one by one a
there are so many. Is there any way I can hyperlink the file names t
the audio .WAV files automatically?


Thank you
Mo
 
Hi Mon
one way: Enter the following in B1
=HYPERLINK("C:\temp\" & A1 & ".WAV",A1)
copy down (of course replace the pathname)
If you like, you can hide column A afterwards

HTH
Frank
 
Back
Top