Hi
You want to know each cell in a workbook that is referenced from one or more
other workbooks ?
I would be happy to be wrong, but I don't believe there is an easy way.
The source workbook (the one which has data referenced from another
workbook) doesn't know it is referenced.
All the information is in the "destination workbook" (the one that is
referencing the external workbook)
That being said --- With your source book not open, you will have to go
through every workbook that references your source and note the target of
every cell that has "external reference" syntax (the existence of a
construct with "[" in it, find the ones that reference your source workbook
and note the sheet and addresses.
If you have a list of the possible "destination worksbooks" this can be done
with some vba coding but I would first search the net to see if somebody
has already tackled at least part of the problem (e.g. creating a list of
references to a source workbook).
Db
[Non-text portions of this message have been removed]
Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go here: http://www.mousetrax.com/techtrax to enter the ezine, then search the ARCHIVES for EXCEL VBA.
----------------------------------
Visit our ExcelVBA group home page for more info and support files:
http://groups.yahoo.com/group/ExcelVBA
----------------------------------
More free tutorials and resources available at:
http://www.mousetrax.com
----------------------------------
Tidak ada komentar:
Posting Komentar