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