Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

How can I programmatically change Link references?

19 views
Skip to first unread message

Boulder_dude

unread,
Apr 24, 2008, 11:31:04 AM4/24/08
to
We're doing a file system upgrade, and changing our server names. Our drive
letters, however, will stay the same (I: and J:), but will be changing from
something like:
\\filesrv1\ABC$
to:
\\filesrv2\ABC$

Subsequently, I have to help people sort out their links in Excel (and other
Office apps), and update those to the new file server name.

I ran a test, and using the same drive letter assigned to the new share does
not do the trick - I get an error "Cannot start the source application for
this object" for Links, and "The Address of this site is not valid. Check the
address and try again." for hyperlinks.

I've done some research, and the Excel VBA .LinkSources Method only reveals
the drive letter. I need a method that will allow me to address (and change)
the full file path (\\filesrv1\abc$\...).

Using the .SourceName Method on an OLEObject also only reveals a string of
the sort:
"MSPhotoEd.3|J:\pictest\testpicture.JPG!"'

On the Hyperlink side, the .Hyperlinks method only exposes
"../../../abc$/pictest/testpic.jpg".

It would be nice if there were a method (like in PPT) that would expose the
"\\filesrv1" so that I could use the Replace function to change it.

Does anyone have any help or experience they could share?
Thanks in advance...

Bill Manville

unread,
Apr 24, 2008, 1:03:32 PM4/24/08
to
I can offer a free LinkManager utility that should address your problem
Email me at Bill_Manville at compuserve.com

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup

Boulder_dude

unread,
Apr 25, 2008, 12:00:00 PM4/25/08
to
Bill - did you not get my email yet requesting that program?

Tom

Susanne Nordmann

unread,
Jun 5, 2008, 10:16:56 AM6/5/08
to
Boulder_dude schrieb:

unfortunatly, i can´t help u....

michael...@googlemail.com

unread,
Jun 20, 2008, 9:32:47 AM6/20/08
to

Hi Bill,

Could you please send me a link for the free software, I have a
similar problem to the original thread in that I have thousands of
excel spreadsheets with hyperlinks on one existing server, I need to
move all data off that server due to disk space running out, the excel
spreadsheet hyperlinks will not work when I move the data,

Any help would be great, will you software work for my problem.
Mike

Bill Manville

unread,
Jun 20, 2008, 4:44:36 PM6/20/08
to
I am assuming your email address is as in the header of your message
and am sending the utility there.
If that is not an email address you use, email me at the address in the
message you quoted.
0 new messages