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

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

thanks for your help,

marti

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