A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Links and Linking
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

How can I programmatically change Link references?



 
 
Thread Tools Display Modes
  #1  
Old April 24th, 2008, 04:31 PM posted to microsoft.public.excel.links
Boulder_dude
external usenet poster
 
Posts: 3
Default 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...

  #2  
Old April 24th, 2008, 06:03 PM posted to microsoft.public.excel.links
Bill Manville
external usenet poster
 
Posts: 258
Default 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

  #3  
Old April 25th, 2008, 05:00 PM posted to microsoft.public.excel.links
Boulder_dude
external usenet poster
 
Posts: 3
Default 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


  #4  
Old June 5th, 2008, 03:16 PM posted to microsoft.public.excel.links
Susanne Nordmann
external usenet poster
 
Posts: 1
Default 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....
  #5  
Old June 20th, 2008, 02:32 PM posted to microsoft.public.excel.links
[email protected]
external usenet poster
 
Posts: 1
Default 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
  #6  
Old June 20th, 2008, 09:44 PM posted to microsoft.public.excel.links
Bill Manville
external usenet poster
 
Posts: 258
Default 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

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 01:23 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.