International Language Functions

D

dl

We are looking for the international eqivalents for the Excel worksheet
functions

AND
CHAR
REPT

For Danish these are respectively

OG
TEGN
GENTAG

We are looking for the following languages. Can anyone help or direct us in
the right direction.

' Russian 7 (Russian Federation)
' Arabic 966 (Saudi Arabia)
' Czech 42 (Czech Republic)
' Farsi 982 (Iran)
' Greek 30 (Greece)
' Hebrew 972 (Israel)
' Hungarian 36 (Hungary)
' Indian 91 (India)
' Japanese 81 (Japan)
' Korean 82 (South Korea)
' Polish 48 (Poland)
' Portuguese (Brazil) 55 (Brazil)
' Simplified Chinese 86 (People's Republic of China)
' Thai 66 (Thailand)
' Traditional Chinese 886 (Taiwan)
' Turkish 90 (Turkey)
' Urdu 92 (Pakistan)
' Vietnamese 84 (Vietnam)Thanks in advance.
 
T

Tom Ogilvy

functions are stored internally as a token or code. It is translated by the
localized version of Excel for display. So if you put in a valid formula in
a cell containing valid builtin functions and it works in your version, it
should work in any version. This is not true for Analysis toolpak functions
since these are in an addin, but none of the functions you ask about are
from the analysis toolpak.

If you are doing VBA, then always enter the formula in US English with the
Formula or FormulaR1C1 methods and it will be translated automatically
 
D

dl

Dodo

This is useful and we will use as a guide, but does not resolve our issues.

Thanks for the contribution.
 
D

dl

Tom



If you are using code to insert the function then this does not seem to
translate the formula automatically. What we have found is that we need to
use the correct country function for this to work. An example is below.



Eg.



Range("a1").formulalocal="=rept(char(150),3)



If we did enter the formual in US English then what would be the code for
this.



Dim intCountry as integer

intCountry =Application.International(xlCountryCode)

Application.International(xlCountryCode)=1

Range("a1").formulalocal="=rept(char(150),3)

Application.International(xlCountryCode)=intCountry



Thanks for your assistance and all others that have contributed to date.



Rgds

dl
 
T

Tom Ogilvy

I said to use Formula or FormulaR1C1, not any formula with LOCAL included in
the name

Range("a1").formula="=rept(char(150),3)"

should work fine.
 
T

Tom Ogilvy

Also, Stephen Bullen has written the "definitive" tome on International
issues. A quote from one of his recent posts:

There's much more about these types of issue in my 'International
Issues' chapter of John Green's "Excel 2002 VBA Programmer's
Reference", which can also be read online on my web site, at:
http://www.oaltd.co.uk/ExcelProgRef/ch22/
 
D

dl

Tom

Thanks for all the help.

dl

Tom Ogilvy said:
Also, Stephen Bullen has written the "definitive" tome on International
issues. A quote from one of his recent posts:

There's much more about these types of issue in my 'International
Issues' chapter of John Green's "Excel 2002 VBA Programmer's
Reference", which can also be read online on my web site, at:
http://www.oaltd.co.uk/ExcelProgRef/ch22/
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top