I haven't tried this, but I would surmise that you could put the names of the
workbooks in cells, such as A1, A2, A3, and then reference those cells, as
such:
=SUM('C:\NORTH BAY TIMMINS\A1\[REPORTCARD.XLS]JAN'!$D$14)


Also, take a look at this:
http://www.rondebruin.nl/ado.htm


--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"BadBoy" wrote:

Good Morning,

I have a data base titled 'DISTRICT YEARLY ROLL-UP'.

This data base looks in a folder called 'NORTH BAY TIMMINS' for the name
'MARTIN114' and looks inside this folder for a file called 'REPORTCARD.XLS'
and finally reads a file called JAN at the location provided below.

=SUM('C:\NORTH BAY TIMMINS\MARTIN114\[REPORTCARD.XLS]JAN'!$D$14)

My question is the following;

There are more names than just 'MARTIN114' in the folder and I wanted to be
able to have my data base read the report card of all names at that location
(JAN'!$D$14)

Is there a way to tell my data base to read the values at JAN'!$D$14 from
all REPORTCARD.XLS from all folders within the 'NORTH BAY TIMMINS' folder?

Thank you in advance :P

-Bad