Linked Spreadsheet

[JKwan]

Is there an easy way using VBA to alter a Linked Spreadsheet. Instead of using Edit - Links, then go thru each link. Ideally, using "search" and "replace" idea.

[Zack Barresse]

Hi JKwan,

I'd suggest MrExcel's Link Hacker (http://www.mrexcel.com/sunshop/index.php?action=item&substart=0&id=11). It's running for $45 but it's a very good utility. If you're looking for a free utility, try Bill Manville's FindLinks.xla (http://www.bmsltd.ie/MVP/Default.htm) add-in. It's a very good utility that I utilize quite often.

HTH

[Bob Phillips]

... try Bill Manville's FindLinks.xla (http://www.bmsltd.ie/MVP/Default.htm) add-in...

Zack,

FYI, Stephen Bullen's site http://www.bmsltd.ie/ is redundant now. He transferred it to http://www.oaltd.co.uk/ after problems in re-newing the domain. At one point it became a quite nasty site, and although it seems to work now, Stephen states the latter as his official site, so it might be a good idea to update any favorites you may have.l

[JKwan]

Thank you Firefytr and xld. This FindLinks will be very handy.