Hi snax500

See
http://www.rondebruin.nl/copy6.htm

Read the information below the macro about changing the code for csv


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"snax500" wrote in message ...
In Excel2003, I have many sheets that I want to save as individual CSV
files. For example, I have forty sheets in one file that I will end up
with 40 CSV files. I want the files to called by their tab name and
saved @ c:\temp. Any help would on a macro would be appreciated.
Thanks