Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel Addins - Index or key
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 -- mangesh_yada ----------------------------------------------------------------------- mangesh_yadav's Profile: http://www.excelforum.com/member.php...fo&userid=1047 View this thread: http://www.excelforum.com/showthread.php?threadid=26916 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel Addins - Index or key
Could perhaps use
addins.count to check for full names via addins.Item(i).FullName |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel Addins - Index or key
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 mangesh_yadav wrote: Hi I am currently setting the Excel Addin "Analysis Toolpak" through the 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 language like french or italian. On opening the file, it gives an error saying index not found. This is obviously because the text "Analysis Toolpak" is "Utilitaire d'analyse" in french and it does not find the english text. If I use Addins(1) this works fine in english but they are arranged in ascending order, this would give a problem as I don't know at what number would the corresponding addin in another language be in the list. Any help on this one. Do these addins have some unique identifier or key. Or if I can refer to its filename somehow. Mangesh |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
excel addins | New Users to Excel | |||
Excel Addins Problem | Setting up and Configuration of Excel | |||
C++ Com Addins for Excel | Excel Programming | |||
Managing Addins in Excel | Excel Programming | |||
Excel Addins | Excel Programming |