On Sat, 15 Aug 2009 15:15:01 -0700, ?B?QmFyYiBSZWluaGFyZHQ=?=
wrote:

=Are there already hyperlinks in the cells? If so, changing the
displayed
=value doesn't necessarily change the hyperlinks. Matthew's way
would work.
=If you want a VBA solution, come back.
=
="Terry" wrote:
=
=
= Excel 2003, XP Pro
=
= I have a single-sheet workbook with 600 and climbing entries in
col A,
= each with a hyperlink. The files in each link are now located on
an
= external drive so that I can work on building the sheet from
different
= computers. Eventually, all the files will be moved to a more
permanent
= location on a different computer, exact address unknown.
=
= My question is: how does one change the addresses of each
hyperlink in
= a global fashion? I really don't want to stroke in new addresses!
=
= Present Address: file:///E:\FOLDER E1\TEMP QSL DATA\Data Filename
=
= Tentative Final Address: file:///C:\FINAL QSL DATA\Data
Filename
=

I'm back!

Answer to your question above, very few have hyperlinks now, for I
quit when I saw a problem (in my mind) of manually re-entering all
hyperlinks using the right-click/hyperlink method.

I wonder if the "Hyperlink Base" function could be used in conjunction
with concatenating the text in the cell, which is the filename, and
then adding ".jpg"?

Something like: Base Hyperlink + filename in cell + .jpg

For example, I am now working from a portable external drive E:\
entering the filename in col A as, say, B6TYY. The actual filename to
which I would like to link (presently while I'm working on the
project) is "file:///E:\folder1\folder2\B6TYY.jpg".

The path above will ultimately have to be changed to something on a
C:\ drive when I'm finished. Could this be done by changing the base
hyperlink?

I don't know how to do this in VB, if it could be done. Could you
help?

TIA--
Terry--WB4FXD
Edenton, NC