Chip Pearson has lots of notes/examples he
http://www.cpearson.com/excel/vbe.aspx

Personally, I'd rather copy the data to worksheets in a different workbook
(maybe based on a template that was set up the way I wanted) and not have to
remove any code.



SHETTY wrote:

Dear Friends

Please tel me how to save copy of excel file through vba code (Modules if
any the files must be removed while saving the file)

Please guide

Ramesh Shetty
Mangalore

--

Dave Peterson