Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming,microsoft.public.dotnet.framework.interop,microsoft.public.vb.com
|
|||
|
|||
![]()
I am new to VB.NET coding for excel, and so am probably missing
something real elementary he I can get an Excel 97 VBA module to successfully include a reference to a VB.NET project that contains the Connect class with the necessary Guid and ProgId attributes and the five IDTExtensibility2 interface methods, including OnConnection. From the VBA module with the reference I need to fire-up code in the project containing the Connect class and then have it accesses the instance of excel with the calling VBA module. What piece of code am I missing to start up the OnConnection method. The docs I read aren't too clear to me about how to do this, making it sound like just the creation of the reference to the VB.NET project containing the IDTExtensibility2 interface might set off OnConnection. However so far I have yet to get a MsgBox to display from OnConnection. I can get code in other classes contained in the same VB.NET project with the IDTExtensibility2 interface to run from VBA, but nothing in OnConnection and thus am unable to have the VB.NET project recognize my Excel 97 Workbook as desired. Thanks so much in advance for your insights |\|. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Please post this thread a correct full method, method about | New Users to Excel | |||
Please post this thread a complete correct method, method about te | New Users to Excel | |||
OT :Start your own online business today !start making dollars | Excel Discussion (Misc queries) | |||
IDTExtensibility2.OnConnection Event | Excel Programming | |||
Why does my AddIn do OnConnection() twice? | Excel Programming |