Accessing of Custom properties of MFC controls in Excel using VSTO

Question

I am trying the following code.

Microsoft.Office.Tools.Excel.Worksheet _worksheet = _vSTOWorkbook.GetActiveToolsWorksheet(_applicationFactory);
Shape _shape = _worksheet.Shapes.AddOLEObject("<My MFC Activex control>");
_shape.OLEFormat.Object.<CustomProperty> = <value>;

While setting the custom property, I am getting RuntimeBinder exception. Is there any other way to achieve what I am trying to get?

Thanks.

---

M Sharma, Deloitte, USA

Answer 1

Hi M Sharma,

I don't think your snippet will work fire for following options:

1. MFC controls can't access directly in the .NET Framework.
2. You need wrap your control via .NET Framework in order to let it can be access in .NET Framework program.

Have a good day,

Tom

Answer 2

maybe try to generate interop type for your com object and cast OLEFormat.Object to this interop type.

Answer 3

Thanks Tom but the same snippet works perfect in Word. Any specific reasons you can think of?

---

M Sharma, Deloitte, USA