Error loading .xll in debug mode

33 views
Skip to first unread message

alexs...@gmail.com

unread,
May 3, 2018, 8:00:28 AM5/3/18
to Excel-DNA
Hello! My prohect worked OK. Then I've added user form1, form1.vb and deleted it from project.
After that when i'm try to load add-in in debug mode from it begin to  throw error.

But when I load compiled xll _not from Visual Studio_ - everything works fine!! Problem is that I cannot debug my project in VS 2017!

Error occures only when I load it from Visual Studio:

ComAddIn [Error] The Ribbon/COM add-in helper required by add-in testribbon1 Add-In could not be registered.
This is an unexpected error.
Error details: System.Reflection.TargetInvocationException: The addressee of a call has created an exception.-> System.Runtime.InteropServices.COMException: Operation is interrupted (An exception from: HRESULT: 0x80004004 (E_ABORT))
---The end of trace of an internal stack of exceptions---
   в System.RuntimeType.InvokeDispMethod(String name, BindingFlags invokeAttr, Object target, Object[] args, Boolean[] byrefModifiers, Int32 culture, String[] namedParameters)
   в System.RuntimeType.InvokeMember(String name, BindingFlags bindingFlags, Binder binder, Object target, Object[] providedArgs, ParameterModifier[] modifiers, CultureInfo culture, String[] namedParams)
   в ExcelDna.Integration.ExcelComAddInHelper.LoadComAddIn(ExcelComAddIn addIn) : TargetInvocationException - The addressee of a call has created an exception.

Govert van Drimmelen

unread,
May 3, 2018, 9:02:17 AM5/3/18
to exce...@googlegroups.com

One cause of the error you see is when Excel puts your ad-in in the “Disabled Items” list.

 

Go to File -> Options -> Add Ins, then “Manage: Disabled Items” and check if anything is there.

This happens easily when debugging, when you stop debugging or have an error in a ribbon callback. Excel detects this and decides to disable your add-in.

 

-Govert

--
You received this message because you are subscribed to the Google Groups "Excel-DNA" group.
To unsubscribe from this group and stop receiving emails from it, send an email to exceldna+u...@googlegroups.com.
To post to this group, send email to exce...@googlegroups.com.
Visit this group at https://groups.google.com/group/exceldna.
For more options, visit https://groups.google.com/d/optout.

Reply all
Reply to author
Forward
0 new messages