Change Hyperlink Destination Folder

In an Excel 2002 worksheet I need to change the destination folder in
a column (750 rows) of hyperlinks.

For example:

file:///C:\Documents and settings\myname\Application
Data\Microsoft\Data\12345.mht

needs to be changed to

file:///E:\My Documents\Travel\2005\Data\12345.mht


file:///C:\Documents and settings\myname\Application
Data\Microsoft\Data\56789.mht

changed to

file:///E:\My Documents\Travel\2005\Data\56789.mht

All the ".mht" files are now in the folder E:\My
Documents\Travel\2005\Data\

TIA

Why don't you do a find and replace.

Replace it with something like this:

=HYPERLINK("file:///E:\My
Documents\Travel\2005\Data\12345.mht","file:///E:\My
Documents\Travel\2005\Data\12345.mht")

I'm not sure if it'll work. Let me know.


"Ron" <[email protected]> wrote in message
news:[email protected]...
> In an Excel 2002 worksheet I need to change the destination folder in
> a column (750 rows) of hyperlinks.
>
> For example:
>
> file:///C:\Documents and settings\myname\Application
> Data\Microsoft\Data\12345.mht
>
> needs to be changed to
>
> file:///E:\My Documents\Travel\2005\Data\12345.mht
>
>
> file:///C:\Documents and settings\myname\Application
> Data\Microsoft\Data\56789.mht
>
> changed to
>
> file:///E:\My Documents\Travel\2005\Data\56789.mht
>
> All the ".mht" files are now in the folder E:\My
> Documents\Travel\2005\Data\
>
> TIA

For hyperlinks that were inserted via Insert|Hyperlink?

If yes, then visit David McRitchie's site:
http://www.mvps.org/dmcritchie/excel/buildtoc.htm
look for:
Fix Hyperlinks (#FixHyperlinks)

=========
Another option that I like when I have lots of hyperlinks to the same location.

I'll put this in a cell (hidden???):
file:///E:\My Documents\Travel\2005\Data\

Then use the =hyperlink() formula:
=hyperlink($a$1 & "12345.mht")

then I just have to change that one cell when the path changes.

I'd actually put the folder in one cell ($a$1) and the filenames in others
(A2:a999)

The
=hyperlink($a$1 & a2,"Click me to see: " & a2)
and drag down my helper column.

I can hide all of column A.



Ron wrote:
>
> In an Excel 2002 worksheet I need to change the destination folder in
> a column (750 rows) of hyperlinks.
>
> For example:
>
> file:///C:\Documents and settings\myname\Application
> Data\Microsoft\Data\12345.mht
>
> needs to be changed to
>
> file:///E:\My Documents\Travel\2005\Data\12345.mht
>
> file:///C:\Documents and settings\myname\Application
> Data\Microsoft\Data\56789.mht
>
> changed to
>
> file:///E:\My Documents\Travel\2005\Data\56789.mht
>
> All the ".mht" files are now in the folder E:\My
> Documents\Travel\2005\Data\
>
> TIA

--

Dave Peterson