Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.links,microsoft.public.excel.programming
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



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Drop down lists from multiple source lists RoofIL Excel Worksheet Functions 3 February 18th 10 09:44 PM
Variable VLOOKUP source and target Vindaloo Excel Worksheet Functions 4 April 11th 06 03:56 PM
From Target to Source Steved Excel Worksheet Functions 1 June 10th 05 05:28 AM
Executing code with opening target workbook Todd Huttenstine[_3_] Excel Programming 1 December 26th 03 02:00 AM
Executing code with opening target workbook Todd Huttenstine[_3_] Excel Programming 0 December 25th 03 08:39 PM


All times are GMT +1. The time now is 12:38 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"