Reading information from all workbooks in a folder...

H

H. Rye

Is there a way I can read the information from all excel books in a given
folder? The number of books and their name may vary from time to time. The
folder consists of up to fifty different books, but the amount of
information i each book is limited.

(Excel 2000)
.....
Regards
Havard Rye
 
D

David Coleman

Hi Havard

Can you be a bit more specific about what you want to achieve? Do you need
to copy all the information from all sheets in all books or ??

Thanks

David
 
Top