LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming,microsoft.public.dotnet.framework.interop,microsoft.public.vb.com
external usenet poster
 
Posts: 10
Default IDTExten2ibility2 OnConnection method: Can't get it to start

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Please post this thread a correct full method, method about Nast Runsome New Users to Excel 8 February 25th 08 03:29 PM
Please post this thread a complete correct method, method about te Nast Runsome New Users to Excel 0 February 23rd 08 09:42 PM
OT :Start your own online business today !start making dollars [email protected] Excel Discussion (Misc queries) 0 May 6th 06 09:29 PM
IDTExtensibility2.OnConnection Event Mircea Pleteriu[_2_] Excel Programming 2 March 18th 05 02:36 AM
Why does my AddIn do OnConnection() twice? Ben Crinion Excel Programming 1 October 13th 04 10:12 AM


All times are GMT +1. The time now is 12:38 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"