When you use a Microsoft Visual Basic for Applications (VBA) macro to save a Comma-separated values (.csv) file, Excel ignores the Microsoft Windows regional setting for the List separator character.
↑ Back to the top
Excel uses the default U.S. regional settings when running a macro. This behavior ensures that the result of running macro code is consistent regardless of the computer's regional settings.
Because the default separator character in English (U.S.) is a comma, Excel uses a comma as the separator.
↑ Back to the top
If you need .csv files to be separated according to the regional settings, click Save As on the File menu to save the file manually.
↑ Back to the top