I have been automating Excel using the COM interface and have had trouble getting addins to load this way. To be more explicit, I create an Excel instance using win32com with Python, then run several functions written in VBA which call functions exposed
What I am attempting is programmatically (in VBA) referencing the addin like this:
AddIns("TSXL").Installed = True
This fails with the error:
Run-time error '1004'
Could not load file or assembly 'ExcelDna.Loader' or one of its dependencies. The system cannot find the file specified.