Trace linked files

[Excel Wannabe]

I am using Excel 2003. Is anyone aware of a tool or code that I could use to
trace which files are linked to another Excel file? I don't mean the Edit,
Links menu. Just the opposite. My department inherited a lot of files that
are linked to each other. We would like to see how they are intermingled so
that we can know which files we can change without damaging others. Thanks
in advance for any help you can offer.

 

[gimme_this_gimme_that]

I've been impress by what I can read in Excel using
MacPerl::Applescript.

To make a long story, short you have access to the entire workbook
from a perl structure.

There are somethings you don't have access too .. Such as anything in
the VBProject (i.e. VBA Modules)

Put together two or three linked example linked files email them to me
and I'll see if I can get you started.

It's a long shot.

This recent post of mine (code shown below) shows you who to get the
data out of Sheet1 of the active workbook. Sometimes it's not clear
what it is that you should fetch from Excel (like I wouldn't have
guessed formula ) but the trick is to access what might have what you
want and in Applescript to a "properties of" on it. And keep doing
that until you get the "MyOtherWorkbook!*" you're in business.

From there you modify your program to go through all the worksheets,

then the workbook, then all workbooks, etc.


#!/usr/bin/perl
use MacPerl::AppleScript;


my $app = MacPerl::AppleScript->new("Microsoft Excel");
$app->execute("launch");
my $vc= $app->execute("get value of formula of range \"A1:B3\" of
worksheet \"Sheet1\" of active workbook");

foreach my $ref (@{$vc}) {
#here, $ref is one of the "inner" references
foreach my $elem (@{$ref}) {
print "$elem ";
}
print "\n";

 

[CyberTaz]

You've found your way into a Mac XL group, but the answer is the same on the
PC... No, at least nothing as far as XL is concerned. The target file
doesn't even know it is being linked to and there is nothing stored
internally to that effect. The file containing the link stores all the link
information & simply "reads" the target file any time the link is refreshed.

 

[Excel Wannabe]

Thanks for the great suggestion about using Perl and for your generous offer
to take a look at the files. Unfortunately, I can't send them to you for
security reasons. Thanks again!