"Tushar Mehta" wrote

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 .

So, you want a list of the files referenced by the target.xls file.
Correct?

Exactly. And I would prefer to get this information without having to first
load the document into Excel.
(IOW, I wish to be able to obtain this info with a command-line tool)



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.

What *does* it return? What should it return? What is the relevant
code?

This macro returns a the list of files that the document is linked do (it
returns
the list we get in the "Edit links" dialog)

How is it different on different PCs?
Probably depending on how the link was created (not sure). The path
displayed
in the Edit Links dialog changes depending on the PC the document is opened.
On one PC it says sth like C:\path. and yet on the other the same links
shows D:\...
We need a script that returns the same list independent on where the
document
was opened.

In any case, you might want to check Bill Manville's FindLink utility,
available from http://www.bmsltd.ie/MVP/MVPPage.asp

Since this needs a workbook to be opened first, it is of not much use
for me. I also tried to look at its source to get some idea on other
possibilities -
but apparently the author does not want us to.

Thanks again,
Cheers
-arifi

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article ,
says...
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