I assume from the lack of response that this cannot be done. Okay, lets try
it another way. What if the sheets were within one workbook?

DDawson

"DDawson" wrote in message
...
Further information/description of my problem...

In a new excel file, how do I:

Get excel to go through each xls file in a folder
Get the values of each cell, in the range A1:G10, in each file, Sheet1
Total the values of each cell, in the range, in each file, sheet 1
Provide the totals of each cell, in the new file, in range A1:G10

Any help on this would be appreciated

Regards
Dylan Dawson
Scotland

"dd" wrote:

Please help;

I have an excel timesheet template covering the activities of a group of
people.
The activity names and personnel names in the table do not change.
A new file is created each week and the filename is the Friday and the
Month
i.e. 1512.xls (15th of December)
I want a new workbook to provide totals of time entered against each
person/activity(as hours) in each file.
I want the file to be live so that it updates as new timesheet files are
created.

I would envisage it as being the same layout as the weekly timesheet, only
it would show overall totals. I don't know how to bring in these totals
from
the external workbooks, or how to keep it 'live' as new files are added.

Thanks
D Dawson
Scotland