list of linking cells

[J_J]

Hi,
Is there a way via VBA to list all the cells that is to retrieve info from
other workbooks (i.e. cells with formulas such as
='D:\[sample.xls]Sheet1'!A11)
TIA
J_J

[keepITcool]

get FindLink addin from
http://www.bmsltd.ie/MVP/Default.htm

--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam


J_J wrote :

> Hi,
> Is there a way via VBA to list all the cells that is to retrieve info
> from other workbooks (i.e. cells with formulas such as
> ='D:\[sample.xls]Sheet1'!A11)
> TIA
> J_J

[J_J]

Thanks keepITcool,
That was cool...
J_J

"keepITcool" <[email protected]> wrote in message
news:[email protected]...
> get FindLink addin from
> http://www.bmsltd.ie/MVP/Default.htm
>
> --
> keepITcool
> | www.XLsupport.com | keepITcool chello nl | amsterdam
>
>
> J_J wrote :
>
>> Hi,
>> Is there a way via VBA to list all the cells that is to retrieve info
>> from other workbooks (i.e. cells with formulas such as
>> ='D:\[sample.xls]Sheet1'!A11)
>> TIA
>> J_J