How can I programmatically change Link references?
 

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...

How can I programmatically change Link references?
 

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

How can I programmatically change Link references?
 

Bill - did you not get my email yet requesting that program?

Tom

"Bill Manville" wrote:

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

How can I programmatically change Link references?
 

Boulder_dude schrieb:
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...


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

How can I programmatically change Link references?
 

On Apr 24, 6:03*pm, Bill Manville wrote:
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

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

How can I programmatically change Link references?
 

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.

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