LInks

[Lee]

Hi! Friends:

I have 2 question which need your helps:


1. I have a big Excel file (the target) in which some of
the cells are linked to another Excel file (the source).
By looking at EDIT/LINK of the target, I can only know the
name of the source file. How can I do a quick search in
the Target to know the cell addresses to which it is being
linked?

2. In VBA, is there a way to 'declare' all variables are
positive, similar to the INTEGER statement used to declare
integer variables?

Thanks.

Lee

 

[Jim Rech]

You can do a Find for the source file's name or you can use Bill Manville's
Find Link utility available on Stephen Bullen's site:

http://www.bmsltd.co.uk/MVP/Default.htm