Hyperlinks:is it possible to change the links automaticaly ?

I have a spreadsheet with around 1000 links to a network location, I need to
copy this info and spreadsheet to a cd to send to a european office, is it
possible to change the links automaticaly ? as to do it manually will take a
long time, thanks for any help offered


--
there are no problems just challenges

Take a look at 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

steve.a wrote:
>
> I have a spreadsheet with around 1000 links to a network location, I need to
> copy this info and spreadsheet to a cd to send to a european office, is it
> possible to change the links automaticaly ? as to do it manually will take a
> long time, thanks for any help offered
>
> --
> there are no problems just challenges

--

Dave Peterson