Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Order of Excel Addin
Hi,
This is basically a follow up question to Charles Williams. Charles, you posted this very nice code to help my VBA addin assure that the C# addin that it depends on is loaded first. dim oAddin as addin on error resume next set oaddin=nothing set oaddin=addins("MyProjectname.c*lassname") on error goto 0 if oaddin is nothing then addins.add("MyProjectname.clas*sname") set oaddin=addins("MyProjectname.c*lassname") endif if not oaddin.installed then oaddin.installed=true And, in fact, the desired effect takes place if the C# addin is not installed. But - the weirdest thing!!! - if I had previously quit Excel with the automation addin "clicked in", then this code does not accomplish its mission and the functions stored in the automation addin are not available to the VBA add-in! Any ideas on what might be going wrong? Grateful, Aaron Fude. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Order of Excel Addin
As it always happens, right after I post I find a workaround (but not a
solution). The following ugly hack fixes the problem: ' If Not oAddin.Installed Then oAddin.Installed = True oAddin.Installed = False oAddin.Installed = True Still, I would like to hear your opinion on what is going on! Aaron Fude |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How stop Excel file UK date order changing to US order in m.merge | Excel Discussion (Misc queries) | |||
Excel C# AddIn | Excel Programming | |||
Excel Addin help!!! | Excel Programming | |||
Remove Excel AddIn from AddIn List !! Help | Excel Programming | |||
Excel COM Addin | Excel Programming |