Mass change Hyperlink reference
 

for some reason, maybe a recent update all my hyperlinked items were changed from this:

...\..\WebPages\
to
.../../../Documents%20and%20Settings/owner/Application%20Data/WebPages/

Is there a simple way to change these all at once or do I have to do it one record at a time?

--

Regards
Michael Koerner

Mass change Hyperlink reference
 

A few people have said that this has resolved the problem for them:

File|Properties|Summary Tab|Hyperlink Base
change it to C:\
(something that's always available)

I like to use the =hyperlink() worksheet function. It has never failed me this
way:

=hyperlink("file:////yourpathtothe/something.xxx","Click me")

==============
If you have to change lots and lots and lots back...

You could use the code from David McRitchie's site:

http://www.mvps.org/dmcritchie/excel/buildtoc.htm
look for:
Fix Hyperlinks (#FixHyperlinks)

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

(If it's just a few, I'd do it manually.)

=====================
ps. This is a plain text newsgroup. Most of us try to not post in RTF/HTML
(and no binary attachments).

Michael Koerner wrote:

for some reason, maybe a recent update all my hyperlinked items were changed
from this:

..\..\WebPages\
to
../../../Documents%20and%20Settings/owner/Application%20Data/WebPages/

Is there a simple way to change these all at once or do I have to do it one
record at a time?

--

Regards
Michael Koerner



--

Dave Peterson

Mass change Hyperlink reference
 

Thanks Dave. will look at all your reference guides. But, although I have a lot to do I will probably end up doing them manually as my macro knowledge is less than zero.

--

Regards
Michael Koerner


"Dave Peterson" wrote in message ...
A few people have said that this has resolved the problem for them:

File|Properties|Summary Tab|Hyperlink Base
change it to C:\
(something that's always available)

I like to use the =hyperlink() worksheet function. It has never failed me this
way:

=hyperlink("file:////yourpathtothe/something.xxx","Click me")

==============
If you have to change lots and lots and lots back...

You could use the code from David McRitchie's site:

http://www.mvps.org/dmcritchie/excel/buildtoc.htm
look for:
Fix Hyperlinks (#FixHyperlinks)

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

(If it's just a few, I'd do it manually.)

=====================
ps. This is a plain text newsgroup. Most of us try to not post in RTF/HTML
(and no binary attachments).

Michael Koerner wrote:

for some reason, maybe a recent update all my hyperlinked items were changed
from this:

..\..\WebPages\
to
.../../../Documents%20and%20Settings/owner/Application%20Data/WebPages/

Is there a simple way to change these all at once or do I have to do it one
record at a time?

--

Regards
Michael Koerner



--

Dave Peterson