Hi Mark,

I found that this post has been posted in several queues.
I have replied you in microsoft.public.dotnet.languages.csharp, please
follow up there. I will work with you.
Thanks for your understanding.

Best regards,
Jeffrey Tan
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.

--------------------
| Content-Class: urn:content-classes:message
| From: "Mark"
| Sender: "Mark"
| Subject: C# and OLEFormat.Object
| Date: Fri, 24 Oct 2003 08:43:46 -0700
| Lines: 32
| Message-ID:
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="iso-8859-1"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| Thread-Index: AcOaRZyyF4hCGNg2SlGEAt2SMgcKeA==
| X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
| Newsgroups: microsoft.public.excel.programming
| Path: cpmsftngxa06.phx.gbl
| Xref: cpmsftngxa06.phx.gbl microsoft.public.excel.programming:427149
| NNTP-Posting-Host: TK2MSFTNGXA13 10.40.1.165
| X-Tomcat-NG: microsoft.public.excel.programming
|
| I have a C# add in that inserts a custom active x control
| into a worksheet.
|
| Once the object is inserted i can locate the object
| through both Shapes and Worksheet.OLEObjects. What I
| can't do is figure out how to use the object
| programatically.
|
| I added a reference to the object in the Visual Studio
| project by importing the object OCX. The reference shows
| up as Interop.ActiveXLib and my objects methods and
| properties are shown in the object browser under both
| interop.ActiveXLib.ImyControl and
| interop.ActiveXLib.ImyControlCtlClass.
|
| I have tried various arrangements of casting the object
| returned from both Shapes and Worksheet's OLEFormat.Object
| trying to get something that I can use directly with no
| success:
|
| ActiveXLib.myControlCtlClass mc =
| (ActiveXLib.myControlCtlClass) shape.OLEFormat.Object;
|
| I am writting the add in Visual Studio .Net and it is
| running in Excel 2002 Service Pack 1.
|
| What I want to do is to be able to use:
| mc.myControlMethod(doIT).
|
| Thanks for the help
|
| Mark
|