Saving CSV file with same settings from several computers in VBA Excel

[TomBex]

Hello people,

I am looking for a solution to save a file as CSV file with Always the same settings for list separator, decimal separator and thousand separator. If I run the macro from my computer the file will be as it should be because my local settings in Windows 10 are Decimal=, ; Thousand=. and semicolon=;. And my VBA code of the Line SaveAs has the argument Local:=True.
But when this macro is run by one of my collegues the CSV file has the separators that are use on American computers (semicolon=, decimal=. and Thousand=,). The collegues can not change their Windows local settings because they run a lot of programs that needs these settings.

My question is now how can we program our VBA code that it looks which user is running this file and macro and than change the local settings for saving this file and then put back the Original local settings. And here is the focus on the semicolon to ;.

The macro that is running now looks like this:

Who can help me in this matter.

 

[Special-K99]

You cant attach files on this forum. There are tools on this forum for adding small spreadsheet images

https://www.mrexcel.com/forum/about-board/508133-attachments.html

Or upload the file to an online storage site and post a link to it, though some people may not download the file for fear of viruses.

 

[TomBex]

Thanks Special-K99,

I didn't know this. I am new to this forum. But maybe the text of my item is obvious enough to explain my problem and to receive an answer.

Tom