The skills you learn for this one script will be portable to a ton of other scripting applications. Opening 300 Excel workbooks in multiple locations and doing a find/replace is a boatload of clicking and at the end of the day, you haven't learned anything by doing that. You'll also miss some links :)
-Jeff Steward On Mon, Sep 26, 2011 at 11:23 AM, Oliver Marshall < [email protected]> wrote: > Alas it’s not, it’s just a bit old. The data will be moved but the server > will be left for cheap (slow) storage.**** > > ** ** > > Thanks Michael but I’m after a util or script that’s ready to go as, I > would imagine, creating something to do this would take as much time as > doing it itself (given my limited programming skills).**** > > ** ** > > Olly**** > > ** ** > > ** ** > > *From:* Kennedy, Jim [mailto:[email protected]] > *Sent:* 26 September 2011 16:18 > > *To:* NT System Admin Issues > *Subject:* RE: Updating all the links in a spreadsheet (search and > replace)**** > > ** ** > > I got nothing on excel specifically but is the original server going out of > service? If yes you can fake it out with a WINS and/or DNS entry.**** > > ** ** > > *From:* Oliver Marshall [mailto:[email protected]] > *Sent:* Monday, September 26, 2011 11: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 to \\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] > 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**** > > > > > > Network Support > Online Backups > Server Management > > Tel: 0845 307 3443**** > > Email: [email protected] > > Web: http://www.g2support.com**** > > Twitter: g2support <http://twitter.com/home?status=@g2support>**** > > Newsletter: http://www.g2support.com/newsletter**** > > Mail: 2 Roundhill Road, Brighton, Sussex, BN2 3RF > > **** > > **Have you said something nice about us to a friend or colleague ? ** > > **Let us ****say thanks. Find out more at www.g2support.com/referral** > > ** ** > > G2 Support LLP is registered at Mill House, 103 Holmes Avenue, HOVE**** > > BN3 7LE. Our registered company number is OC316341. **** > > ~ 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 > ~ 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
<<personal229.jpg>>
<<g2supportsmall_250x58border4823.png>>
