Felix Atagong
Active Member
- Joined
- Jun 27, 2003
- Messages
- 359
I have daily Excel files to convert in 'European' CSV format, this is delimited with a semicolon.
If I open the file and do a 'manual' Save As CSV my file is allright.
When I write a macro and do a
ActiveWorkbook.SaveAs Filename:=Firma, FileFormat:=xlCSV, CreateBackup:=True
the delimiter is a comma. I tried with CSVWindows but the macro does NOT follow my 'default' windows separator which is semicolon (Excel 2000).
Anyone has a VBA solution or isn't there any?
PS: I can't change all commas in a semicolon afterwards because some of my 'fields' have commas in them, that's why I use semicolon as a separator!
If I open the file and do a 'manual' Save As CSV my file is allright.
When I write a macro and do a
ActiveWorkbook.SaveAs Filename:=Firma, FileFormat:=xlCSV, CreateBackup:=True
the delimiter is a comma. I tried with CSVWindows but the macro does NOT follow my 'default' windows separator which is semicolon (Excel 2000).
Anyone has a VBA solution or isn't there any?
PS: I can't change all commas in a semicolon afterwards because some of my 'fields' have commas in them, that's why I use semicolon as a separator!