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