Split %date% in a batch file regardless of Regional Settings

Four years have passed, but this question doesn’t get old, and I think now there’s a slightly better answer than using wmic (on win7 onwards). for /F “tokens=1,2,3 delims=_” %%i in (‘PowerShell -Command “& {Get-Date -format “MM_dd_yyyy”}”‘) do ( set MONTH=%%i set DAY=%%j set YEAR=%%k ) echo %MONTH% %DAY% %YEAR% With powershell Get-Date you can … Read more

Different languages issue when inserting formula from VBA

VBA is very EN-US-centric. VBA’s .Formula and .FormulaR1C1 expect the ROW function. To use regional language function ‘flavors’ like СТРОКА then the Range.FormulaLocal property or Range.FormulaR1C1Local property should be employed instead. The same holds true for list separator characters. Use a comma (e.g. ,) to separate the arguments in a function when using .Formula or … Read more