try looking at this - I found it invaluable
http://j-walk.com/ss/excel/eee/eee009.txt

-----Original Message-----
I wish to open all the worksheets in a particular
folder. Then i want
to be able to extract information from each worksheet,
and its
filename, without entering a filename. Is this
possible? How do I do
it?

the reason I want to is quite simple. I have hundreds of
worksheets
with inconsistant names, and I want to apply a macro to
each, and save
time by having the macro open, extract, and close the lot.

thanks for your help,

martin


---
Message posted from http://www.ExcelForum.com/

.