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