I am looking to total the amount of a certain cell taken from the first
worksheet from each workbook in all directories and subdirectories. The file
and worksheet name is the same in each directory and subdirectory. This
total will then be displayed in a new xls file which will keep an updated
quanity. I have been playing with more scripting, only I can not find one
that will successfully make it down through all of the subdirectories...

"Rick Rothstein (MVP - VB)" wrote:

The file structure is as such (with different names);

Home
- Building 1
- 102 Charly
- Documents
- 104 Dave
- Documents
- 111 Fred
- Documents
- Building 2
- 221 Mary
- Documents
- 234 Sue
- Documents
- 258 Lisa
- Documents

The xls file is in the documents folder. The workbook has the same name
and
the worksheet is also the same name. It is on a network mapped drive.

A follow up question... are you looking to combine worksheets in all the
Building directories taken together, or in each Building directory
individually?

Rick