CSV Semicolon Comma problem with Macro.

Good Day Everybody,

We have a slight problem with a macro when we save a xls to csv file when using a macro to do this.

We made the following macro which saves the current file as a CSV file:

Please Login or Register  to view this content.

When we use the macro it saves the CSV file with a comma, but we require a semicolon.
When we save the file manually it always uses a semicolon, because keyboard-settings are on ;

What do we forget ?

Thanks and regards,

Raymond

Local:=True means the delimiter should be coming from your computer's Control Panel setting for delimiter.

http://screencast.com/t/hWH00ju2wu

No, CSV is a comma delimited file type, that's what it IS. The Local:=True setting is supposed to allow you to override that default with your own system's default delimiter. That's really it, that's suppposed to do exactly what you're trying to do.

Maybe try this:

Please Login or Register  to view this content.

It opens the csv file, reads the contents, and converts all commas into semicolons.

Hope this helps.

abousetta

Then perhaps take a little control over the reference workbook being created. Does this do any better:

Please Login or Register  to view this content.