If you're lucky, you could look through all the formulas looking for .xls or
..xls].

But those links can hide in mysterious places.

I'd get a copy of Bill Manville's FindLink program:
http://www.oaltd.co.uk/MVP/Default.htm

To see if the code found everything.

Daffo wrote:

Hi everybody, i want to know how to do this. Suppose there is a work
sheet by name WrkSheet1 in WorkBook1 and there is another work sheet by
name WrkSheet4 in WorkBook2. WrkSheet1 is linked to WrkSheet4( WrkSheet4
uses data from WrkSheet1 as input). How do i find out if WrkSheet1 has
any dependencies or external references. I want to do this
*Programmatically using VB*.

I apologise if this has already been discussed. If it has already been
discussed plz let me know as to where i can find it.

With Regards,
Daffo.

--
Daffo
------------------------------------------------------------------------
Daffo's Profile: http://www.excelforum.com/member.php...o&userid=37472
View this thread: http://www.excelforum.com/showthread...hreadid=571337

--

Dave Peterson