Macro to save each sheet with existing name and to the location specified

Hi Friends,

One of the member (patel45) has help me in creating a macro to import .csv file with predefined name.

http://www.excelforum.com/excel-prog...rename-it.html

Now i want to create a command button and assign a macro which will save each sheet with existing sheet name & and to the location predefined. please help me with macro code.


Thanks in advance

Yes each sheet should be saved in different location...

Please help

anyone there to help me???