switch between excel regional settings while remaining in a workbook

[BSALV]

When i use the XL2BB-tool to download data from this site in my workbook in "dutch" regional setting, the formulas remain english and therefore unprocessed.

* Is it possible to change my setting to english, import the XL2BB-data and switch back to dutch ? (= just english setting during 30 seconds !!! )
* Later, to share the results here on the site with that same XL2BB-tool, to do just the same, switch to english and use the XL2BB-tool, because yesterday i saw that conditional format formulas remained in dutch.

Should that even be possible, to make a macro to make that switch forwards and backwards automatically ?
example of such a XL2BB-import, the formulas are kind of strings

Map2
	I	J	K	L	M	N	O	P
11	=IF(F11,$B$1,0)	=PRODUCT(G11,$B$2)	=SUM(I11,J11)	=SUM(C11*$B$3,B11)*$B$4	=PRODUCT(G11,$B$5)	=SUM(K11,L11,M11)	=IF(B11<=$E$4,$F$4,IF(B11<=$E$5,$F$5,IF(B11>=$E$6,$F$6)))	#WAARDE!
Blad1

Cell Formulas
Range	Formula
P11	P11	=N11-O11

 

[Marc L]

​

In fact whatever the local Excel version the Excel inner engine is still natively in english​

so this is very easy to directly translate any english formula to your local version​

via for example the VBE watch window (Ctrl + G) with a single codeline like ActiveSheet.UsedRange.Formula = ActiveSheet.UsedRange.Value2 …​

​

So to see your dutch formula in english in the VBE watch window : ?ActiveCell.Formula so no necessary to change the Windows Regional settings.​

 

[BSALV]

i just tried it on a threat here, funny, a simple sum wasn't handled okay and other more complicated formulas okay.
I 'll do a few other test and i'll come back.
Thanks.