'System.Runtime.InteropServices.COMException' in UIAComWrapper.dll

[Alberto Ghiglia]

Hello Govert,

I get the error message “'System.Runtime.InteropServices.COMException' in UIAComWrapper.dll” when I try to open for the second time with excel the same workbook

 

This error has been fired after I wrote the following code:

 

Private WithEvents CurrentExcelApplication As Microsoft.Office.Interop.Excel.Application       

 

Private Sub App_WorkbookOpen(ByVal Wb As Workbook) Handles CurrentExcelApplication.WorkbookOpen

 

            PrendiDatiFiltri(LabelFiltriControl)

' PrendiDatiFiltri is the “GetText” of an editbox included in the Addin.dna. Pls see below

 

            'Refresh del Ribbon

            MyExcelRibbon.Invalidate()

'MyExcelRibbon is defined in a General class as:

'Public Shared MyExcelRibbon As ExcelDna.Integration.CustomUI.IRibbonUI

 

End Sub

 

 

Addin.dna:

 

….

            <group id="_Filtri"  label="Gestione Filtri">

              <editBox id="_editboxDue"

                             tag="InfoBoxDue"

                             label=" "

                             sizeString ="123456789012345678901234567890"

                             maxLength ="30"

                             showLabel ="true"

                             getText="PrendiDatiFiltri"

                             enabled="false" />

            </group>

 

 

It seems to be related to ExcelDNA DLL?

Many thanks in advance

 

Alberto

 

[Alberto Ghiglia]

Hi Govert

Yes, I’m using intellisense extension

 

I made the two following steps_

1)      I installed the NUGet package 1.0.4 in a directory of the project

2)      In the prokect references:

·         I deleted the reference to the old DLL

·         I changed the reference new DLL 1.0.4.31383

 

Did I miss something for the correct installation of the new Intellisense package?

(just to be sure to have done everything….)

 

With 1.04 it seems to work fine now!

Thanks!!

 

Alberto

 

Da: Govert van Drimmelen [mailto:gov...@icon.co.za]
Inviato: mercoledì 6 settembre 2017 17:52
A: Alberto Ghiglia <alberto....@gmail.com>
Oggetto: RE: 'System.Runtime.InteropServices.COMException' in UIAComWrapper.dll

 

Hi Alberto,

 

Are you using the Excel-DNA IntelliSense extension – this is the only part that could use UIAComWrapper.dll.

The current version of the IntelliSense extension (since v 1.0.3) no longer uses UIAComWrapper.dll, so you might like to update.

 

If you’re not using the Excel-DNA IntelliSense extension, maybe another add-in is using it…

 

Do you see this exception only under the debugger?

 

-Govert

[Govert van Drimmelen]

With the ExcelDna.IntelliSense NuGet package through the Visual Studio package manager, you should not need to add a reference manually - it should automatically add a reference to the library inside the package. So I'm not sure what procedure you followed.

(You still need to have a call to IntelliSenseServer.Register() in your AutoOpen method).

But if it works it's probably OK.

-Govert

---

From: exce...@googlegroups.com [exce...@googlegroups.com] on behalf of Alberto Ghiglia [alberto....@gmail.com]
Sent: 07 September 2017 10:04 AM
To: exce...@googlegroups.com
Subject: [ExcelDna] R: 'System.Runtime.InteropServices.COMException' in UIAComWrapper.dll

--
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.