Home |
Search |
Today's Posts |
#6
![]()
Posted to microsoft.public.excel.links,microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Drop down lists from multiple source lists | Excel Worksheet Functions | |||
Variable VLOOKUP source and target | Excel Worksheet Functions | |||
From Target to Source | Excel Worksheet Functions | |||
Executing code with opening target workbook | Excel Programming | |||
Executing code with opening target workbook | Excel Programming |