Hi Patric,

Try this:

objBook.SaveAs(blahblahblah,6)

The second parm is FileFormat. There are a gazillion file formats; 6 is equal to the Excel constant xlCSV.


>Once again I find myself in the need of great minds!
>
>I've got a routine that opens an Excel spreadsheet (using CreateObject), makes several changes, then saves the spreadsheet under a new name using objBook.SaveAs(blahblahblah) where blahblahblah represents the new filename.
>
>All is good and well..... However, I now need to save the open spreadsheet off with the new name as a CSV file instead of a standard Excel spreadsheet.
>
>Any ideas? I'm not having any problems opening, changing, etc.. just can't seem to get the syntax to actually save the thing off as something other than an excel spreadsheet.
>
>As always, everyone's input is always welcome and appreciated! :-)