software

I had to move an excel file that I have over 200 hyperlinks to specific files
inside the same folders. The main hyperlink is common to all of the
hyperlinks, I need to know if there is a way I can do a search and replace a
piece of the hyperlink in excel. I'm using MS Excel 2003 SP1

Take a look at David McRitchie's site:
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:
www.mvps.org/dmcritchie/excel/getstarted.htm

bnbbond wrote:
gt;
gt; I had to move an excel file that I have over 200 hyperlinks to specific files
gt; inside the same folders. The main hyperlink is common to all of the
gt; hyperlinks, I need to know if there is a way I can do a search and replace a
gt; piece of the hyperlink in excel. I'm using MS Excel 2003 SP1

--

Dave Peterson

Outstanding tip - I was fretting about changing 200-400 hyperlinks in a
spreadsheet (because the server name had changed) but this script did the job
in seconds.quot;Dave Petersonquot; wrote:

gt; Take a look at David McRitchie's site:
gt; www.mvps.org/dmcritchie/excel/buildtoc.htm
gt; look for:
gt; Fix Hyperlinks (#FixHyperlinks)
gt;
gt; If you're new to macros, you may want to read David McRitchie's intro at:
gt; www.mvps.org/dmcritchie/excel/getstarted.htm
gt;
gt; bnbbond wrote:
gt; gt;
gt; gt; I had to move an excel file that I have over 200 hyperlinks to specific files
gt; gt; inside the same folders. The main hyperlink is common to all of the
gt; gt; hyperlinks, I need to know if there is a way I can do a search and replace a
gt; gt; piece of the hyperlink in excel. I'm using MS Excel 2003 SP1
gt;
gt; --
gt;
gt; Dave Peterson
gt;

I'm sure David McRitchie will be pleased that it worked for you.

haslamslane wrote:
gt;
gt; Outstanding tip - I was fretting about changing 200-400 hyperlinks in a
gt; spreadsheet (because the server name had changed) but this script did the job
gt; in seconds.
gt;
gt; quot;Dave Petersonquot; wrote:
gt;
gt; gt; Take a look at David McRitchie's site:
gt; gt; www.mvps.org/dmcritchie/excel/buildtoc.htm
gt; gt; look for:
gt; gt; Fix Hyperlinks (#FixHyperlinks)
gt; gt;
gt; gt; If you're new to macros, you may want to read David McRitchie's intro at:
gt; gt; www.mvps.org/dmcritchie/excel/getstarted.htm
gt; gt;
gt; gt; bnbbond wrote:
gt; gt; gt;
gt; gt; gt; I had to move an excel file that I have over 200 hyperlinks to specific files
gt; gt; gt; inside the same folders. The main hyperlink is common to all of the
gt; gt; gt; hyperlinks, I need to know if there is a way I can do a search and replace a
gt; gt; gt; piece of the hyperlink in excel. I'm using MS Excel 2003 SP1
gt; gt;
gt; gt; --
gt; gt;
gt; gt; Dave Peterson
gt; gt;

--

Dave Peterson

This worked great for me also.
I am having a problem though.
When i do correct the hyperlinks, some of them go back to the
previous way it was, or changes to some wierd format and I'm unable to use
the links at all.
Do you know what might be happening, or do i need to be more specific?

quot;Dave Petersonquot; wrote:

gt; I'm sure David McRitchie will be pleased that it worked for you.
gt;
gt; haslamslane wrote:
gt; gt;
gt; gt; Outstanding tip - I was fretting about changing 200-400 hyperlinks in a
gt; gt; spreadsheet (because the server name had changed) but this script did the job
gt; gt; in seconds.
gt; gt;
gt; gt; quot;Dave Petersonquot; wrote:
gt; gt;
gt; gt; gt; Take a look at David McRitchie's site:
gt; gt; gt; www.mvps.org/dmcritchie/excel/buildtoc.htm
gt; gt; gt; look for:
gt; gt; gt; Fix Hyperlinks (#FixHyperlinks)
gt; gt; gt;
gt; gt; gt; If you're new to macros, you may want to read David McRitchie's intro at:
gt; gt; gt; www.mvps.org/dmcritchie/excel/getstarted.htm
gt; gt; gt;
gt; gt; gt; bnbbond wrote:
gt; gt; gt; gt;
gt; gt; gt; gt; I had to move an excel file that I have over 200 hyperlinks to specific files
gt; gt; gt; gt; inside the same folders. The main hyperlink is common to all of the
gt; gt; gt; gt; hyperlinks, I need to know if there is a way I can do a search and replace a
gt; gt; gt; gt; piece of the hyperlink in excel. I'm using MS Excel 2003 SP1
gt; gt; gt;
gt; gt; gt; --
gt; gt; gt;
gt; gt; gt; Dave Peterson
gt; gt; gt;
gt;
gt; --
gt;
gt; Dave Peterson
gt;

Some people have said that if they change the hyperlink base
(file|properties|summary tab)
to something that is always available (C:\ for instance), it can help stop those
links from changing.

Maybe it'll work for you.

But that won't help fix the already messed up links.

I try to use the =hyperlink() worksheet function. I've never seen them do
anything bad.
bnbbond wrote:
gt;
gt; This worked great for me also.
gt; I am having a problem though.
gt; When i do correct the hyperlinks, some of them go back to the
gt; previous way it was, or changes to some wierd format and I'm unable to use
gt; the links at all.
gt; Do you know what might be happening, or do i need to be more specific?
gt;
gt; quot;Dave Petersonquot; wrote:
gt;
gt; gt; I'm sure David McRitchie will be pleased that it worked for you.
gt; gt;
gt; gt; haslamslane wrote:
gt; gt; gt;
gt; gt; gt; Outstanding tip - I was fretting about changing 200-400 hyperlinks in a
gt; gt; gt; spreadsheet (because the server name had changed) but this script did the job
gt; gt; gt; in seconds.
gt; gt; gt;
gt; gt; gt; quot;Dave Petersonquot; wrote:
gt; gt; gt;
gt; gt; gt; gt; Take a look at David McRitchie's site:
gt; gt; gt; gt; www.mvps.org/dmcritchie/excel/buildtoc.htm
gt; gt; gt; gt; look for:
gt; gt; gt; gt; Fix Hyperlinks (#FixHyperlinks)
gt; gt; gt; gt;
gt; gt; gt; gt; If you're new to macros, you may want to read David McRitchie's intro at:
gt; gt; gt; gt; www.mvps.org/dmcritchie/excel/getstarted.htm
gt; gt; gt; gt;
gt; gt; gt; gt; bnbbond wrote:
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; I had to move an excel file that I have over 200 hyperlinks to specific files
gt; gt; gt; gt; gt; inside the same folders. The main hyperlink is common to all of the
gt; gt; gt; gt; gt; hyperlinks, I need to know if there is a way I can do a search and replace a
gt; gt; gt; gt; gt; piece of the hyperlink in excel. I'm using MS Excel 2003 SP1
gt; gt; gt; gt;
gt; gt; gt; gt; --
gt; gt; gt; gt;
gt; gt; gt; gt; Dave Peterson
gt; gt; gt; gt;
gt; gt;
gt; gt; --
gt; gt;
gt; gt; Dave Peterson
gt; gt;

--

Dave Peterson