Hello everyone.



I have a workbook with a number of sheets say sheet1, sheet2, sheet3 etc..

I need a macro to save:

sheet1 to C:\data\sheet1\sheet1.xls

sheet2 to C:\data\sheet2\sheet2.xls

sheet3 to C:\data\sheet3\sheet3.xls



folder sheet1, sheet2 and sheet3 cannot be replaced because they have special rights assigned to them.



Your help will be greatly appreciated.



Regards,