Command Translator

[Guest]

Hi,

I am using English commands to program Excel-Access etc., but unfortunately my office xp pro.is a german version, because of my location. Do I have to use MS Office 2000 command translator for this problem or is there any new solutions for MS Office XP?

Regards

M. Onat Ozdemiroglu

 

[Tom Ogilvy]

VBA operates in English in all versions (xl97 and later).

--
Regards,
Tom Ogilvy

Hi,

I am using English commands to program Excel-Access etc., but

unfortunately my office xp pro.is a german version, because of my location.
Do I have to use MS Office 2000 command translator for this problem or is
there any new solutions for MS Office XP?

 

[keepITcool]

General rule :

All excel files will produce same results opened in whichever version.

Exceptions.. HERE we go:

worksheet =>
avoid using functions from analysis toolpak.
these will NOT translate automatically.

avoid using functions with "hardcoded" string arguments like the CELL()
function. = ZELLE("datei",a1)

if you cant avoid them use =ZELLE("filename",a1)..
(but is you'd do it from VBA you'll need to use
.Formula = "=CELL(""filename"",a1)



For VBA:
in principle NEVER use the 'local' properties and methods:
e.g. use .FORMULA (but avoid FORMULALOCAL)

Be carefull with conversion of dates and non integer numbers.




--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam


M. Onat Ozdemiroglu wrote :