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

Are the addin names supplied with Excel language specific?

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


"Howard Kaikow" wrote in message
...
Will Application.AddIns("Analysis ToolPak") work with non-English versions
of Excel?

Are the addin names supplied with Excel language specific?

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/2...-addin-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.

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/2...-addin-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

"Norman Jones" wrote in message
...
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

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!

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

"Norman Jones" wrote in message
...
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.

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

"Abdul" wrote in message
...


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?

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.

"Howard Kaikow" wrote in message
...
"Norman Jones" wrote in message
...
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?

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

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

The Ruussian version, if required, is:

ЧИСТВ�ДОХ



---
Regards.
Norman


"Peter T" <peter_t@discussions wrote in message
...
"Howard Kaikow" wrote in message
...
"Norman Jones" wrote in message
...
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?

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

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

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

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

"Norman Jones" wrote in message
...
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?

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