wilmott.com

When I launch Excel through the Windows Explorer, a certain set of addins gets loaded as part of my user preferences. These addin preferences seem to be lost when I open an Excel instance via the PythonCOM interface. How can I launch Excel and enforce the addin loading process so that the same addins get loaded with a PythonCOM instance as with a non-automation instance?If it makes a difference, I am using the DispatchEx method from win32com:xl = DispatchEx("Excel.Application")

When you instance-ize Excel from via the com interface you will generally need to load each add-in because they should be ignored in the instance object. I think there are a few examples about this on MSDN.

Thanks for the heads up - I have been unable to find any reference to this on the MSDN forums. How can an addin be loaded programmatically with an Excel instance? I've tried a few things, including loading via a VBA function (works for some addins, does not work when loading ExcelDNA addins), also tried opening the addins manually as workbooks - this also failed. Any ideas on how to do this?

If you want to do this in VB then you use Createobject("WScript.Shell")e.g.http://www.tek-tips.com/viewthread.cfm? ... 5&page=484

These should help:http://support.microsoft.com/default.as ... us;q213489

Thanks for the replies - I was able to get around the problem by doing the following:1. Open the XLA / XLL file representing the addin in question2. Set addins(addin_name).Installed = False3. Addins(addin_name).Add(addin_file_path)4. Set addins(addin_name).Installed = True