C# and OLEFormat.Objec t?

[Mark]

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.OLEOb jects. 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.ActiveX Lib and my objects methods and
properties are shown in the object browser under both
interop.ActiveX Lib.ImyControl and
interop.ActiveX Lib.myControlCt lClass.

I have tried various arrangements of casting the object
returned from both Shapes and Worksheet's OLEFormat.Objec t
trying to get something that I can use directly with no
success:

ActiveXLib.myCo ntrolCtlClass mc =
(ActiveXLib.myC ontrolCtlClass) 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.myControlMet hod(doIT).

Thanks for the help

Mark

Hi Wei-Dong Xu,

Are you saying that it is impossible to get hold of the
actual object from the add in code that i showed you
before?

I don't understand how a macro helps here. I don't see an
obvious API to create or call such a macro from my C# add
in.

I think you are saying that i should do something like;

application.bui ldNamedMacroCal l("macroName" ,
stringWithMacro Commands)

application.cal lTheNamedMacroJ ustCreated()

PLEASE PROVIDE AN EXAMPLE.

Thank You

Mark

-----Original Message-----
Hi Mark,

Thank you for replying!

I'd suggest that you can build one marco for your inserted ActiveX control, then you can all the macro in
your add-in. In this way, you don't need toretrieve the object type information of the inserted ActiveX control.
Please feel free to let me know if you have any further questions.
Does this answer your question? Thank you for using Microsoft NewsGroup!
Wei-Dong Xu
Microsoft Product Support Services
Get Secure! - www.microsoft.com/security
This posting is provided "AS IS" with no warranties, and confers no rights.

.

[Mark]

Hi Wei-Dong Xu,

Are you saying that it is impossible to get hold of the
actual object from the add in code that i showed you
before?

I don't understand how a macro helps here. I don't see an
obvious API to create or call such a macro from my C# add
in.

I think you are saying that i should do something like;

application.bui ldNamedMacroCal l("macroName" ,
stringWithMacro Commands)

application.cal lTheNamedMacroJ ustCreated()

PLEASE PROVIDE AN EXAMPLE.

Thank You

Mark

-----Original Message-----
Hi Mark,

Thank you for replying!

I'd suggest that you can build one marco for your inserted ActiveX control, then you can all the macro in
your add-in. In this way, you don't need toretrieve the object type information of the inserted ActiveX control.
Please feel free to let me know if you have any further questions.
Does this answer your question? Thank you for using Microsoft NewsGroup!
Wei-Dong Xu
Microsoft Product Support Services
Get Secure! - www.microsoft.com/security
This posting is provided "AS IS" with no warranties, and confers no rights.

.
..

-----Original Message-----
Hi Mark,

Thank you for replying!

I'd suggest that you can build one marco for your inserted ActiveX control, then you can all the macro in
your add-in. In this way, you don't need toretrieve the object type information of the inserted ActiveX control.
Please feel free to let me know if you have any further questions.
Does this answer your question? Thank you for using Microsoft NewsGroup!
Wei-Dong Xu
Microsoft Product Support Services
Get Secure! - www.microsoft.com/security
This posting is provided "AS IS" with no warranties, and confers no rights.

.

[Wei-Dong Xu [MSFT]]

Hello Mark,

Try the following example, based onthe Microsoft Knowledge Base article
302902:

Add a Project Reference to the Micosoft Excel PIA
Add the following to the Usings
using System.Windows. Forms;
using Excel = Microsoft.Offic e.Interop.Excel ;
Change the declaration of the applicationObje ct to
private Excel.Applicati on applicationObje ct;
private void MyButton_Click( CommandBarButto n cmdBarbutton,re f bool
cancel)
{
try
{
//Get the workbooks collection.
Excel.Workbooks objBooks_Late =
(Excel.Workbook s)applicationOb ject.GetType(). InvokeMember( "Workbooks" ,
BindingFlags.Ge tProperty, null, applicationObje ct, null );

//Get the active workbook.
object[] Parameters;

Excel.Workbook objBook_Late = objBooks_Late[1];

//Get the worksheets collection.
Excel.Sheets objSheets_Late = objBook_Late.Wo rksheets;

//Get the first worksheet.
Excel.Worksheet objSheet_Late = (Excel.Workshee t)objSheets_Lat e[1];

// Get workbook
// TEST LINE #1
Microsoft.Vbe.I nterop.VBProjec t obVBP = objBook_Late.VB Project;

// More Code that creates and inserts strings into a
VBIDE.VBCompone nt code module.
//¡*¡*
//¡*¡*
}

catch(Exception ex)
{
System.Windows. Forms.MessageBo x.Show("Why this Error?: "
+ ex.Message);
}

}

Chris Jensen (Microsoft)