Giganews Newsgroups
Subject: LInks
Posted by:  Lee (e2718…
Date: Wed, 8 Oct 2003

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

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