VBA save as file type

Hi,
I have some code which basically selects a customer record from one sheet,
pulls in all the months invoices relating to that client on another sheet,
selects alll the invoices,
copies to a new workbook
saves it in a specified location
loops onto the next client record, and so on.

Everything works fine, apart from I need to save it as a CSV, not an excel workbook.

THis is the bit of code that saves the workbook, what do I need to add to this:

Please Login or Register  to view this content.

in particular this bit:

Please Login or Register  to view this content.

Help appreciated, thanks in advance.

Cheers
Dan.

Record a macro while saving a test file as a CSV to get basic code...

Thanks, yes I had thought of that -

If i save as CSV it will remove the macro i have just recorded, so when I open again i can't view the code.

thank you!