Re: Getting source lists w/o opening target file

From: Arifi Koseoglu (arifi_at_tnn.net)
Date: 05/24/04 

Date: Mon, 24 May 2004 13:33:22 +0300

"Tushar Mehta" <tmUnderscore200310@tushar-mehta.SeeOhEm> 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 <915dc3ae.0405230801.10a45bed@posting.google.com>,
> arifi@turk.net 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
> >

Relevant Pages

  • Re: Mail merge Word/Excel Dilaogue/Database Engine error
    ... I did understand those basic parts, but the Macro parts are way too deep. ... "Peter Jamieson" wrote: ... the Excel document might be very large ... the user opens the document (is that just using Word ...
    (microsoft.public.word.mailmerge.fields)
  • Re: Autonew
    ... The equivalent macro name in Excel is Auto_Open. ... |I have a excel document which contains a template for an invoice. ... | I am going to create a userform in excell which will show itself whenever ... | I tried to do this using excell but autonew macro doesnt seem to self ...
    (microsoft.public.excel.programming)
  • Deleting lines with a variable.
    ... In my macro I want to delete some lines depending on a test. ... I loop through some lines and do a check whether to delete the line. ... Prev by Date: ...
    (microsoft.public.excel.programming)
  • [PATCH 1/1] Add missing include into include/linux/netdevice.h
    ... Depending on configuration options, the latter ... is either defined as a macro or is declared as a function in another header ...
    (Linux-Kernel)
  • Excel 97 document and a possible macro
    ... We have an excel document that is viewed by at times by multiple users. ... spreadsheet to be updated via a scheduled task. ... With word the /m macroname commandline option made word run the macro upon ... option does not seem to be in the excel startup options, ...
    (microsoft.public.office.misc)