Change regional format via VBA

[Bering]

Hello,

Does anyone know a reliable way to temporarily change the regional format settings and switch them back to the default settings via VBA? I understand this could be done using API but I tried to adjust the below code to my needs without success:

Change region format to another language with VBA

I would need to:
run my macro, determine whether the settings are French - Switzerland, if so, change the settings from French - Switzerland to English GB, resume my macro and switch back to the default settings.

Thank you very much for any idea.

 

[BSALV]

why would you do that ?
Can't you tackle your problem instead of using the big tools ?
Changing the regional settings,

 

[Bering]

why would you do that ?
Can't you tackle your problem instead of using the big tools ?
Changing the regional settings,

I work for a francophone company while I am not, so I use English settings while my colleagues prefer French.. ugh
I honestly don’t want to rewrite all my macros to take into account different date formats and decimal separators.
At the moment, they simply change manually their regional settings when they use my macros and then set them back. I am just looking for some ideas to fix this through vba.
Thanks