Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.links
|
|||
|
|||
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
Posted to microsoft.public.excel.links
|
|||
|
|||
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
Posted to microsoft.public.excel.links
|
|||
|
|||
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
Posted to microsoft.public.excel.links
|
|||
|
|||
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
Posted to microsoft.public.excel.links
|
|||
|
|||
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
Posted to microsoft.public.excel.links
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
trying to programmatically change chart data range with vb.net | Charts and Charting in Excel | |||
checkboxes and cell-link references...is there a better way | Excel Worksheet Functions | |||
checkboxes and cell-link references | Excel Discussion (Misc queries) | |||
Formula Link References Change to Startup Directory | Links and Linking in Excel | |||
3-D References and Link Updates | Excel Worksheet Functions |