Command Translator

  • Thread starter M. Onat Ozdemiroglu
  • Start date
M

M. Onat Ozdemiroglu

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
 
T

Tom Ogilvy

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

--
Regards,
Tom Ogilvy

M. Onat Ozdemiroglu said:
Hi,

I am using English commands to program Excel-Access etc., but
Click to expand...
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?
 
K

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 :
 
Top