Hello,
I have an excel file consisting of around 60 sheets. Each sheet i
named after the code of a customer/dealer. Now, I want to save eac
sheet as a new excel file with the name of the file as the name of th
sheet itself. (ie. I want to have 60 new excel files with eac
customer/dealer details sheet as one file). If one sheet is name
A0005, then this sheet should be saved as A0005.xls.

I would be very grateful if anyone of you can write a macro here whic
will allow me to be able to save such sheets as a new excel file.

Thank you very muc

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