View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.links,microsoft.public.excel.programming
Arifi Koseoglu[_2_] Arifi Koseoglu[_2_] is offline
external usenet poster
 
Posts: 2
Default Getting source lists w/o opening target file

Many thanks Tushar, many thanks Bill! I see that I probably should change
aim and probaby trace the links back to the machines they were originally
created on... .... Not happy. I will also look into the java toolkit Tushar
mentioned.
Cheers
-arifi

"Bill Manville" wrote in message
...
Arifi Koseoglu wrote:
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)


It might be possible to write such a tool, which would have to decode the

XLS
file format to find the external link records (no easy task). As far as I
know no-one has done so.

We need a script that returns the same list independent on where the
document was opened.


For links to files on the same drive as the file containing the link, this

is
unlikely as such links are in effect held relatively. So the source of

the
link depends on where the file containing the link is located.



Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup