Take a look at the SaveAs method in XL/VBA Help.

You need to use the fileformat argument...



In article .com,
"broogle" wrote:

I am trying to save a sheet to CSV file (users are free to choose the
location to save this file). I am able to do it, but when I open the
file, only the extension is CSV but the format still XLS (all formula,
, color, format still there).