>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! :-)
#define xlCSV 6
objBook.SaveAs(cFilename, xlCSV)
Cetin