In the Excel Object Model, it shows up as an OLE object; which isn't very easy to deal with in scripting. Can it be done? I suspect so. Would it be easy? Not a chance.
Regards, Michael B. Smith Consultant and Exchange MVP http://TheEssentialExchange.com From: Hilderbrand, Doug [mailto:[email protected]] Sent: Wednesday, October 19, 2011 10:42 AM To: NT System Admin Issues Subject: RE: Updating all the links in a spreadsheet (search and replace) Same question but not about hyperlinks. When users use OLE/COM, embedding a spreadsheet into a Word doc or another spreadsheet, how do you handle those? I'm not even sure if you can search for that. We have a server with hundreds of thousands of files we want to break up somehow to handle storage issues. Over 1TB of aggregated storage. Doug Hilderbrand From: Oliver Marshall [mailto:[email protected]]<mailto:[mailto:[email protected]]> Sent: Monday, September 26, 2011 8:17 AM To: NT System Admin Issues Subject: Updating all the links in a spreadsheet (search and replace) Anyone know of a tool that will allow us to replace all the links within a spreadsheet, ideally in a folder full of them, with a new link? We have a Master spreadsheet that pulls data out of some 300 spreadsheets within a nest of folders. We are moving the whole lot to a new server and need to update all the links and references from \\server\share\files\blah.xls<file:///\\server\share\files\blah.xls> to \\server_two\share\files\blah.xls<file:///\\server_two\share\files\blah.xls>. Any suggestions? Olly ~ Finally, powerful endpoint security that ISN'T a resource hog! ~ ~ <http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/> ~ --- To manage subscriptions click here: http://lyris.sunbelt-software.com/read/my_forums/ or send an email to [email protected]<mailto:[email protected]> with the body: unsubscribe ntsysadmin ________________________________ Check out the new Crane Aerospace Electronics Newsroom<http://newsroom.craneae.com/>! Like us on Facebook<http://www.facebook.com/home.php?#!/pages/Crane-Aerospace-Electronics/163305413682908>! We value your opinion! <http://www.craneae.com/surveys/satisfaction.htm> How may we serve you better? Please click the survey link to tell us how we are doing: http://www.craneae.com/surveys/satisfaction.htm Your feedback is of the utmost importance to us. Thank you for your time. Crane Aerospace & Electronics Confidentiality Statement: The information contained in this email message may be privileged and is confidential information intended only for the use of the recipient, or any employee or agent responsible to deliver it to the intended recipient. Any unauthorized use, distribution or copying of this information is strictly prohibited and may be unlawful. If you have received this communication in error, please notify the sender immediately and destroy the original message and all attachments from your electronic files. ________________________________ ~ Finally, powerful endpoint security that ISN'T a resource hog! ~ ~ <http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/> ~ --- To manage subscriptions click here: http://lyris.sunbelt-software.com/read/my_forums/ or send an email to [email protected]<mailto:[email protected]> with the body: unsubscribe ntsysadmin ~ Finally, powerful endpoint security that ISN'T a resource hog! ~ ~ <http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/> ~ --- To manage subscriptions click here: http://lyris.sunbelt-software.com/read/my_forums/ or send an email to [email protected] with the body: unsubscribe ntsysadmin
