And don't forget to adjust the path to an existing folder.

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

Michael MacLachlan wrote:

Is it possible to export certain areas from Sheets in a workbook
automatically to single .CSV Files with the name of the sheet ?
E.G.: The Range A:5 - Z:89 for the Sheets named Argentina, Austria,...
should produce .CSV Files named : Argentina.csv, Austria.csv ......

--

Dave Peterson