Hyperlinks and the Display field

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Rob Walker (Robert_j_walker_at_hotmail.com)
Date: 08/05/04 

Date: 5 Aug 2004 07:22:12 -0700

Hi there,

I'm not much of an excel programmer but I'm looking for a solution to
something that might save me a lot of work.....

I have an excel sheet containing descriptions of about 4000 sound
effects as wav files stored on a local drive. I've built a search
function to go through and find keywords which works well. Each
description is in its own cell. You click on a description, such as
"Dog bark" and it hyperlinks to the relevant wav and you hear it.
Great so far. It's simple and it works.

I've just got about another 6000 files to integrate into this system.
The first time round, I manually hyperlinked every single file. Which
was very dull and time consuming. Having done some trawling around, I
can get myself as far as having the description text in one column
(i.e. what excel calls Display in the hyperlink dialog box) and the
relevant hyperlink in the column next to it. Whilst this isn't the
end of the world, it does mean some scrolling about and is not very
elegant. Does anyone know of an automated way to merge the two, so
that the 6000 descriptive "display" fields are given their associated
hyperlink in the same cell without me linking every single one again
manually?

Thanks in an advance for any assistance,

Rob

Relevant Pages

  • Re: using html links as data in mail merge w/ office 2003
    ... I have never 'defined' function in Excel VBA. ... hyperlink "link text", ... You can either split out the link text and display text ... Then you could insert column D, call it linktext, insert the following Excel ...
    (microsoft.public.word.mailmerge.fields)
  • Re: Active hyperlinks in mail merge
    ... As far as I know there is no way to insert a complete hyperlink in Excel into Word during a mailmerge using the out-of-the-box mailmerge, assuming that the "link text" and the "display text" can be different from each other. ... Delete the old display text so you just end up with the {MERGEFIELD myhl} ...
    (microsoft.public.word.mailmerge.fields)
  • Re: Excel Hyperlinks to my Media Player do not work
    ... How can I turn off the hyperlink warning in Excel 2003? ... installed K-Lite Mega Pack and my Windows Media Player can now finally play ... setup 50 hyperlinks to 50 FLV files located in the same directory where my ...
    (microsoft.public.excel.misc)
  • Re: merged field to hyperlink
    ... The hyperlink I was referencing is shown in Figure 5. ... > manually disguise the URL each time they send out the email. ... >> would require an extra mergefield to insert the display text. ... >>> which is a field from Excel. ...
    (microsoft.public.word.docmanagement)
  • Re: using html links as data in mail merge w/ office 2003
    ... I have never 'defined' function in Excel VBA. ... hyperlink "link text", ... You can either split out the link text and display text ... Then you could insert column D, call it linktext, insert the following Excel ...
    (microsoft.public.word.mailmerge.fields)