Macro to save file as CSV (Comma Delimited)

There's three types of CSV files: CSV (Macintosh), CSV (MS-DOS), and CSV (Comma delimited).

I have a macro to autosave my file and I need CSV (Comma Delimited). When I look at the files I save correctly they just say .csv at the end, but this isn't saving as the type I need. Any ideas.

Please Login or Register  to view this content.

Include the FileFormat argument.

Please Login or Register  to view this content.

Yes Alpha frog! That totally worked.

Hello,
I have a similar issue. My macro is working, but my VBA seems to be different then yours, Where would i enter the "FileFormat:=1CSV" on the below code?

ThisWorkbook.Sheets("Combined").Copy Before:=wb.Sheets(1)
wb.SAVEAS "S:\Production Department\Tracking import\Tracking Import File.NOT READY" & Format(Date, "MM.DD.YY") & ".csv"
End Sub

Hello to all,

I just used the above code. It works fantastic but is it possible just save the active sheet to csv and not changing the properties of the workbook?
i.e. When the code is run the active sheet name changes to the exported csv name. I want to keep the workbook to the original condition without having to close (without saving) it and reopen it.

Thank you in advance.