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

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

--
Regards,
Tom Ogilvy

"M. Onat Ozdemiroglu" <M. Onat wrote
in message ...
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

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 :

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