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! :-)