Hello everyone,

I need a method to extract the list of documents an excel document is
linked to *without* opening the file (or, if it definitely has to be
opened, whe need the non-unc named links .

In other words: Lets say I have an excel document called
"target.xls"
which has cells linked to (get data from) cells in files
"d:\folder1\f1.xls" and
"\\server1\share1\s1.xls"

I need a tool that returns me the following list when run on the file
target.xls:
d:\folder1\f1.xls
\\server1\share1\s1.xls

We have written a macro which tries to do the same thing by loading
the target.xls and then retrieving this info. If all links are in
\\server... form, this works fine. However for links in the form
"d:\folder1\f1.xls" the path returned differs depending on where
(which PC) the script is run, i.e. where the target.xls was opened.

We need the forms exactly as how the user who created them entered
into the cells, in order to deduce the exact file name by tracing back
the mappings on every users PC.

Maybe, the question at the top can be re-phrased as:
We need a method to extract the list of documents an excel document is
linked to *without* opening the file OR, if it definitely has to be
opened, whe need a method that returns the non-unc links in the form
they were originally created without being modified depending on where
the document was opened.

There are thousands of files so manual work is not possible.

Any pointers GREATLY appreciated.
Many thanks in advance,
-arifi