Internationalization: Addin names

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Howard Kaikow - 27 May 2008 00:07 GMT

Will Application.AddIns("Analysis ToolPak") work with non-English versions
of Excel?

Are the addin names supplied with Excel language specific?

Reply to this Message

Norman Jones - 27 May 2008 01:24 GMT

Hi Howard,

See Ron de Bruin's discussion at:

Reverse compatibility problem of the old ATP
functions in non English versions of Excel
http://www.rondebruin.nl/atp.htm

For translations of the ATP functions (and all
Excel functions), see KeepITcool's excellent addin:

TranslateIt
Multilingual Formula Translator Addin
http://members.chello.nl/jvolk/keepitcool/addins.html

---
Regards.
Norman

> Will Application.AddIns("Analysis ToolPak") work with non-English versions
> of Excel?
>
> Are the addin names supplied with Excel language specific?

Reply to this Message

Howard Kaikow - 27 May 2008 19:15 GMT

Thanx, those articles are intersting, but I have the following situation.

I am programmatically creating an Excel worbook.

I use

With .AddIns("Analysis ToolPak")
.Installed = vbFalse
.Installed = vbTrue
End With

To assure that the Analysis ToolPak is loaded.

This raises 3 issues:

1. Since the Analysis ToolPak is not in Excel 2007, I can skip that step in
Excel 2007.

2. But, for Excel 97-2003, my question remains, is the name of the addin
"Analysis ToolPak" in all language versions of Excel?

3.
http://www.dicks-blog.com/archives/2004/12/18/replacing-the-analysis-toolpak-add
in-part-1/,
since the article is dated in 2004, seems to state that, for Excel 97-2003,
the ATP function names are not translated to local equivalents.

So the question becomes "Is XIRR the name of the XIRR function in all
language versions of Excel 97-2003?". Elsewhere, it was stated that Excel
2007 does translate the names of functions created in Excel 2007.

Reply to this Message

Norman Jones - 27 May 2008 23:16 GMT

Hi Howard,

=============
Thanx, those articles are intersting, but I have the following situation.

I am programmatically creating an Excel worbook.

I use

With .AddIns("Analysis ToolPak")
.Installed = vbFalse
.Installed = vbTrue
End With

To assure that the Analysis ToolPak is loaded.

This raises 3 issues:

1. Since the Analysis ToolPak is not in Excel 2007, I can skip that step in
Excel 2007.

2. But, for Excel 97-2003, my question remains, is the name of the addin
"Analysis ToolPak" in all language versions of Excel?
=============

An Italian version returns the follwing information:

Name: ANALYS32.XLL
Fullname: C:\Programmi\Microsoft
Office\OFFICE11\LIBRERIA\ANALYSIS\ANALYS32.XLL

Name: ATPVBAEN.XLA
Fullname: C:\Programmi\Microsoft
Office\OFFICE11\LIBRERIA\ANALYSIS\ATPVBAEN.XLA

=============
3.
http://www.dicks-blog.com/archives/2004/12/18/replacing-the-analysis-toolpak-add
in-part-1/,
since the article is dated in 2004, seems to state that, for Excel 97-2003,
the ATP function names are not translated to local equivalents.

So the question becomes "Is XIRR the name of the XIRR function in all
language versions of Excel 97-2003?". Elsewhere, it was stated that Excel
2007 does translate the names of functions created in Excel 2007.
=============

You can obtain the names of the individual
functions in most poular European lanuages
with the TranslateIt add-in which I directed
you to in my previous response.

So, for example, it would return Tir.X as
the Italian name for the XIRR function.

---
Regards.
Norman

Reply to this Message

Howard Kaikow - 28 May 2008 00:56 GMT

> An Italian version returns the follwing information:
>
[quoted text clipped - 5 lines]
> Fullname: C:\Programmi\Microsoft
> Office\OFFICE11\LIBRERIA\ANALYSIS\ATPVBAEN.XLA

The name of interest is
"Analysis ToolPak", not the file name

> So, for example, it would return Tir.X as
> the Italian name for the XIRR function.

Is that for Excel 97-2003?

Because of this thread, I went out to buy another computer a few hours ago,
so I could use Office 2007. Seems that the fates are against me.

Is this an omen?

For a very, very long time, I have needed a laptop computer.
Today, I found interesting stuff at the Lenovo web site, but was not looking
forward to spending time fiddling with the configurations available.

Then I recalled that Costco had a good deal on an HP notebook.
Checking at the Costco web site, none were available.

So I called the local warehouse and was told that they had 2 in stock.
So I got dressed and drove to the store.
When I got there I was told that there were still 2 in stock, lucky me!

So I hustled to the register and paid, only to find out that none were in
stock.

Was this an omen telling me to not buy what I cannot afford?

In any case, Costco gave me a raincheck.
Hmmm, and it was raining today!

What else can go wrong, go wrong!

Reply to this Message

Norman Jones - 28 May 2008 02:39 GMT

Hi Howard,

===========

> So, for example, it would return Tir.X as
> the Italian name for the XIRR function.

Is that for Excel 97-2003?
===========

Excel97-2007.

The function names do not change in Excel 2007;
a significant change is that ATP functions in an
Excel 2007 workbook will automatically be
transalated into the lanuage of another Excel 2007
user.

The ATP translator Addin by Eric Desert, which
can be downloaded from Ron de Bruin's site,
provides, amongst other significant ATP
internationalisation features, an ATP Function
Table in numerous European languages. You can
information and screenshots of the Addin at:

http://www.rondebruin.nl/atptranslator.htm

There is also a download link at that page.

===========
Because of this thread, I went out to buy another computer a few hours ago,
so I could use Office 2007. Seems that the fates are against me.
===========

I suspect that your earlier, interesting exchanges
with Peter T, in your 'Geting around XIRR error' t
thread, may have had a greater bearing!

===========
Is this an omen?

For a very, very long time, I have needed a laptop computer.
Today, I found interesting stuff at the Lenovo web site, but was not looking
forward to spending time fiddling with the configurations available.

Then I recalled that Costco had a good deal on an HP notebook.
Checking at the Costco web site, none were available.

So I called the local warehouse and was told that they had 2 in stock.
So I got dressed and drove to the store.
When I got there I was told that there were still 2 in stock, lucky me!

So I hustled to the register and paid, only to find out that none were in
stock.

Was this an omen telling me to not buy what I cannot afford?

In any case, Costco gave me a raincheck.
Hmmm, and it was raining today!

What else can go wrong, go wrong
===========

Hopefully, the platitude that good things are
worth waitng for will prove to be true!

---
Regards.
Norman

Reply to this Message

Howard Kaikow - 28 May 2008 07:26 GMT

> The ATP translator Addin by Eric Desert, which
> can be downloaded from Ron de Bruin's site,
> provides, amongst other significant ATP
> internationalisation features, an ATP Function
> Table in numerous European languages. You can
> information and screenshots of the Addin at:

All I need is a list of the equivalent names for XIRR, nothing else.

Is there documentation on how to pull out such a list?

> I suspect that your earlier, interesting exchanges
> with Peter T, in your 'Geting around XIRR error' t
> thread, may have had a greater bearing!

Ayup, it wore me out!!

I believe that the notebook comes with a 60/90 day trial of 2007 Student
Teacher EDition, not to mention lots of other crapware.

Afte 90 daze I'll buy the retail Office2007 so I can use it on bothe th
notebook and a (to be built) desktop.

Reply to this Message

Abdul - 28 May 2008 08:05 GMT

>Since the Analysis ToolPak is not in Excel 2007, I can skip that step in
>Excel 2007.

Is this right?

I have Analysis ToolPak in my Excel 2007. Can I manage without
activating it?

Thanks

Abdul

Reply to this Message

Howard Kaikow - 28 May 2008 09:11 GMT

> >Since the Analysis ToolPak is not in Excel 2007, I can skip that step in
> >Excel 2007.
[quoted text clipped - 3 lines]
> I have Analysis ToolPak in my Excel 2007. Can I manage without
> activating it?

Dunno.

The implication of statements by others, in this thread, is that the ATP
functions are no longer orphans and are included with the regular worksheet
functions.

Reply to this Message

Peter T - 28 May 2008 10:28 GMT

> > The ATP translator Addin by Eric Desert, which
> > can be downloaded from Ron de Bruin's site,
[quoted text clipped - 6 lines]
>
> Is there documentation on how to pull out such a list?

It's an interesting addin (I don't just mean its purpose). Here's the list,
at least of the translations it includes.

English : XIRR
Danish : INTERN.RENTE
Dutch : IR.SCHEMA
Finnish : SISÄINEN.KORKO.JAKSOTON
French : TRI.PAIEMENTS
German : XINTZINSFUSS
Italian : TIR.X
Norwegian : XIR
Portuguese : XTIR
Spanish : TIR.NO.PER
Swedish : XIRR

"Analysis-ToolPak" titles in French & Spanish
"Utilitaire d'analyse", "Herramientas-de-Analisis"

I don't know if the actual addin names differ. Try and attract the attention
of Ron de Bruin, I suspect he can advise you more.

> > I suspect that your earlier, interesting exchanges
> > with Peter T, in your 'Geting around XIRR error' t
> > thread, may have had a greater bearing!
>
> Ayup, it wore me out!!

Even with all that OJ & V8 !

Regards,
Peter T

Reply to this Message

Norman Jones - 28 May 2008 11:11 GMT

Hi Howard, Hi Peter,

> "Analysis-ToolPak" titles in French & Spanish
> "Utilitaire d'analyse", "Herramientas-de-Analisis"

Just to add, the Italian version is:

Strumenti di analisi

> English : XIRR
> Danish : INTERN.RENTE
[quoted text clipped - 7 lines]
> Spanish : TIR.NO.PER
> Swedish : XIRR

The Ruussian version, if required, is:

ЧИСТВНДОХ

---
Regards.
Norman

>> > The ATP translator Addin by Eric Desert, which
>> > can be downloaded from Ron de Bruin's site,
[quoted text clipped - 40 lines]
> Regards,
> Peter T

Reply to this Message

Howard Kaikow - 28 May 2008 18:34 GMT

How does one get that list from the addin?
I've not seen any documentation of how to (ab)use the addin.

Reply to this Message

Norman Jones - 28 May 2008 19:15 GMT

Hi Howard,

Select the Bi-directional Translation option
Select 'English' in the first dropdown
Select XIRR in the second lefthand dropdown
Select a language of choice from the third dropdown

The translated function name appears in the
last dropdown.

To cycle though each translation, sequentially
select each language in the third dropdown.

---
Regards.
Norman

> How does one get that list from the addin?
> I've not seen any documentation of how to (ab)use the addin.

Reply to this Message

Howard Kaikow - 28 May 2008 20:23 GMT

> Hi Howard,
>
[quoted text clipped - 8 lines]
> To cycle though each translation, sequentially
> select each language in the third dropdown.

Thanx.

Is not there a way to do that programmatically?

Reply to this Message

Norman Jones - 28 May 2008 20:34 GMT

Hi Howard,

=============

> Select the Bi-directional Translation option
> Select 'English' in the first dropdown
> Select XIRR in the second lefthand dropdown
> Select a language of choice from the third dropdown

> The translated function name appears in the
> last dropdown.

> To cycle though each translation, sequentially
> select each language in the third dropdown.

Thanx.

Is not there a way to do that programmatically?
=============

Perhaps I misunderstand you!

Having now got the list of translations -
or, rather, those provided by Eric Desert
and KeepITcool, what is that you want
to programme?

---
Regards.
Norman

Reply to this Message