I've got a problem which the standard Excel package (97/2000/XP)
doesn't seem to be able to handle.

Just a little background w/o the specifics...

Daily, I am generating statistics on my server with each reading saved
as a separate text file. Each of these text files is then converted to
individual Excel workbooks. Workbook names follow the convention
stat.YYYYMMDDhhmm.xls.

Most of the work is done on a MASTER.xls which pulls in and
manipulates data from the individual "stat.YYYYMMDDhhmm.xls" files.
Each column kind of represent the stats for each day, with each row
representing the different parameters.

Here's the question...

In the MASTER.xls, can I have a cell (in each column) where I enter
the name of the file ("stat.YYYYMMDDhhmm.xls") and have all the cells
in that column use what is entered as part of their reference to the
values in the individual "stat.YYYYMMDDhhmm.xls"?

TIA!!

The function you'd want to use is called =indirect(). But the bad news is it
won't work with closed workbooks.

So if you have those stat.*.xls workbooks open, you can do it.

But Harlan Grove posted a function that opens the other workbook and retrieves
the value from a separate instance of excel:
http://google.com/groups?threadm=oZx...newsranger.com

david_news2000 wrote:
>
> I've got a problem which the standard Excel package (97/2000/XP)
> doesn't seem to be able to handle.
>
> Just a little background w/o the specifics...
>
> Daily, I am generating statistics on my server with each reading saved
> as a separate text file. Each of these text files is then converted to
> individual Excel workbooks. Workbook names follow the convention
> stat.YYYYMMDDhhmm.xls.
>
> Most of the work is done on a MASTER.xls which pulls in and
> manipulates data from the individual "stat.YYYYMMDDhhmm.xls" files.
> Each column kind of represent the stats for each day, with each row
> representing the different parameters.
>
> Here's the question...
>
> In the MASTER.xls, can I have a cell (in each column) where I enter
> the name of the file ("stat.YYYYMMDDhhmm.xls") and have all the cells
> in that column use what is entered as part of their reference to the
> values in the individual "stat.YYYYMMDDhhmm.xls"?
>
> TIA!!

--

Dave Peterson
(E-Mail Removed)

Thanks!!!


Dave Peterson <(E-Mail Removed)> wrote in message news:<(E-Mail Removed)>...
> The function you'd want to use is called =indirect(). But the bad news is it
> won't work with closed workbooks.
>
> So if you have those stat.*.xls workbooks open, you can do it.
>
> But Harlan Grove posted a function that opens the other workbook and retrieves
> the value from a separate instance of excel:
> http://google.com/groups?threadm=oZx...newsranger.com
>
> david_news2000 wrote:
> >
> > I've got a problem which the standard Excel package (97/2000/XP)
> > doesn't seem to be able to handle.
> >
> > Just a little background w/o the specifics...
> >
> > Daily, I am generating statistics on my server with each reading saved
> > as a separate text file. Each of these text files is then converted to
> > individual Excel workbooks. Workbook names follow the convention
> > stat.YYYYMMDDhhmm.xls.
> >
> > Most of the work is done on a MASTER.xls which pulls in and
> > manipulates data from the individual "stat.YYYYMMDDhhmm.xls" files.
> > Each column kind of represent the stats for each day, with each row
> > representing the different parameters.
> >
> > Here's the question...
> >
> > In the MASTER.xls, can I have a cell (in each column) where I enter
> > the name of the file ("stat.YYYYMMDDhhmm.xls") and have all the cells
> > in that column use what is entered as part of their reference to the
> > values in the individual "stat.YYYYMMDDhhmm.xls"?
> >
> > TIA!!