Thank-you for the macro.But where are the csv files getting writen.
tried searching for them in the complete C drive.could not find them.

Is it possible to write the csv files in the same directory where th
excel sheet is located.

Thanks a lot

excelguru

--
excelgur
-----------------------------------------------------------------------
excelguru's Profile: http://www.excelforum.com/member.php...nfo&userid=882
View this thread: http://www.excelforum.com/showthread.php?threadid=27363