How to bypass and force other regional settings in XLS?

[jbesclapez]

Hello,

I have a CSV file that needs to be loaded into another system. This CSV is using a unique format.

We are aware that the user windows regional settings will impact the CSV format saved by XLS.

How can we have a VBA macro that bypass the user regional settings and use a specific defined one?
Is it possible without VBA and without changing user regional settings?

Thanks

 

[jimrward]

Can you elaborate more on the specific settings that are causing the issues maybe with some samples of data, even if you have to change some values for confidentiality

 

[jbesclapez]

Can you elaborate more on the specific settings that are causing the issues maybe with some samples of data, even if you have to change some values for confidentiality

Hi @jimrward and thanks for your reply.
I do not need the info anymore... so lets ignore this. But thanks for offering your help.
Have a good day