Excel Addins - Index or key

[mangesh_yadav]

Hi

I am currently setting the Excel Addin "Analysis Toolpak" through th
sub Auto_Open using the following piece of code

Sub Auto_Open()
If (AddIns("Analysis ToolPak").Installed = False) Then
AddIns("Analysis ToolPak").Installed = True
End If
end sub

Now there is a problem if the OS of the user is using another languag
like french or italian. On opening the file, it gives an error sayin
index not found. This is obviously because the text "Analysis Toolpak
is "Utilitaire d'analyse" in french and it does not find the englis
text.

If I use Addins(1) this works fine in english but they are arranged i
ascending order, this would give a problem as I don't know at wha
number would the corresponding addin in another language be in th
list.

Any help on this one. Do these addins have some unique identifier o
key. Or if I can refer to its filename somehow.

Manges

 

[Jim]

Could perhaps use

addins.count

to check for full names via

addins.Item(i).FullName

 

[keepITcool]

another note:

since apparently you'll be working in an international
environment.. AVOID THE TOOLPAK!

workbooks that contain functions from the AnalysisToolpak
DO NOT translate automatically.

e.g. using the weeknum function in English Excel..
sending it to a Dutch colleague will give him (or her)
a NAME# error. (as the Dutch functions is called WEEKNUMMER())


Yep.. it's truely one of MS's better efforts
Excel has grown from 4.5 to 9.8 MB (xl97 to xl2003),
why not include the damned functions in excel itself...?
or in a properly coded dll?




keepITcool

< email : keepitcool chello nl (with @ and .) >
< homepage: http://members.chello.nl/keepitcool >