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