the point:
there is NO translation involved.
just assign to the USenglish properties/methods
and excel formula bar in the UI will display the localized string.
The localized string depends on 2 (TWO!) INDEPENDENT things:
Excel Language version for the local names of functions.
Regional Settings for separators etc
(optionally with override in xl2002,
if use system separators (Tools/Options.International) is unchecked..
--
keepITcool
|
www.XLsupport.com | keepITcool chello nl | amsterdam
Stefi wrote :
Good point, the correct version is
"... will translate the
FormulaR1C1 ="IF(,,)" statement into the Hungarian =HA(;;) cell
content, even if you recorded it in Swedish as =OM(;;) ..."
supposed that the Swedish separator is also";" (what I don't know).
Stefi
€˛keepITcool€¯ ezt Ć*rta:
NOTE:
the FormulaR1C1 property uses english function names
and NONlocalized (std USENGLISH) separators.
=IF(;;) will give errors! and s/b like:
=IF(rc[1]1.23,9,-9)
Note that recording "formula entry" yields USEnglish formulas.
--
keepITcool
www.XLsupport.com | keepITcool chello nl | amsterdam
Stefi wrote :
Automation is only partly language-dependent, because a VBA
script is always in English, so transferring a sript from e.g.
Swedish environment into Hungarian the latter version will
translate the FormulaR1C1 ="IF(;;)" statement into the Hungarian
=HA(;;) cell content, even if you recorded it in Swedish as
=OM(;;). Thus it will work, EXCEPT if you have put a Swedish
language formula directly in the worksheet. This is a hypothesis,
I didn't test it. Regards,
Stefi