C# Excel add-in: Why need InvokeMember to get Application property?

[Russell Smith]

I am creating an Excel add-in. Please note project type is Shared Add-in
vice Excel Workbook. In the OnStartupComple te event handler I am adding a
new menu item. I start by getting a reference to the Tools menu. This
works fine.

Type applicationType = applicationObje ct.GetType();
CommandBars bars = (CommandBars)ap plicationType.I nvokeMember(
"CommandBar s", BindingFlags.Ge tProperty, null, applicationObje ct,
null);
CommandBar bar = bars["Tools"];
Debug.WriteLine (bar.Name);

But the following more readable code throws "An unhandled exception of type
'System.Executi onEngineExcepti on' occurred in testaddin.dll" on the third
line.

Excel.Applicati on app = (Excel.Applicat ion)application Object;
CommandBars bars = app.CommandBars ;
CommandBar bar = bars["Tools"];
Debug.WriteLine (bar.Name);

I have read Programming Office Applications Using Microsoft Visual C#
(http://msdn.microsoft.com/library/de.../OffCSharp.asp)
and the potential problem I see is "Handling Parameterized Properties with
Excel". But that doesn't seem applicable or the first version wouldn't work
correctly. What gives?

[Nicholas Paldino [.NET/C# MVP]]

Russel,

The only thing I can think of is that the version of excel that you are
testing your add in against is different than the version that the interop
library was generated for. Is this possible?
--
- Nicholas Paldino [.NET/C# MVP]
- mv*@spam.guard. caspershouse.co m

"Russell Smith" <rlsmith @ caci dot com> wrote in message
news:Oo******** *******@TK2MSFT NGP14.phx.gbl.. .

I am creating an Excel add-in. Please note project type is Shared Add-in
vice Excel Workbook. In the OnStartupComple te event handler I am adding a
new menu item. I start by getting a reference to the Tools menu. This
works fine.

Type applicationType = applicationObje ct.GetType();
CommandBars bars = (CommandBars)ap plicationType.I nvokeMember(
"CommandBar s", BindingFlags.Ge tProperty, null, applicationObje ct,
null);
CommandBar bar = bars["Tools"];
Debug.WriteLine (bar.Name);

But the following more readable code throws "An unhandled exception of
type 'System.Executi onEngineExcepti on' occurred in testaddin.dll" on the
third line.

Excel.Applicati on app = (Excel.Applicat ion)application Object;
CommandBars bars = app.CommandBars ;
CommandBar bar = bars["Tools"];
Debug.WriteLine (bar.Name);

I have read Programming Office Applications Using Microsoft Visual C#
(http://msdn.microsoft.com/library/de.../OffCSharp.asp)
and the potential problem I see is "Handling Parameterized Properties with
Excel". But that doesn't seem applicable or the first version wouldn't
work correctly. What gives?

[Russell Smith]

I checked references and worked around the problem but am not sure whether
this is the right approach. The default Shared Add-in project contains a
reference named "Office".

Description: <blank>
Identity: Office
Path: C:\WINDOWS\Micr osoft.NET\Frame work\v1.1.4322\ Office.dll

I noticed that the default VSTO Excel Workbook project contains a reference
named "Microsoft.Offi ce.Core".

Description: Microsoft Office 11.0 Object Library
Identity: {2DF8D04C-5BFA-101B-BDE5-00AA0044DE52}\2 .3\0\primary
Path:
C:\WINDOWS\asse mbly\GAC\Office \11.0.0.0__71e9 bce111e9429c\Of fice.dll

When I deleted the Add-In project's Office reference and replaced it with
the same reference used by the Excel Workbook project, it worked fine. I
have no idea which is the correct reference to use. Based on the DLL file
timestamps, the first was installed as part of Office 2003, the second was
installed as part of VSTO.

Please enlighten me.

V/R
Russell

"Nicholas Paldino [.NET/C# MVP]" <mv*@spam.guard .caspershouse.c om> wrote in
message news:%2******** *********@TK2MS FTNGP11.phx.gbl ...

Russel,

The only thing I can think of is that the version of excel that you are
testing your add in against is different than the version that the interop
library was generated for. Is this possible?
--
- Nicholas Paldino [.NET/C# MVP]
- mv*@spam.guard. caspershouse.co m

"Russell Smith" <rlsmith @ caci dot com> wrote in message
news:Oo******** *******@TK2MSFT NGP14.phx.gbl.. .

I am creating an Excel add-in. Please note project type is Shared Add-in
vice Excel Workbook. In the OnStartupComple te event handler I am adding a
new menu item. I start by getting a reference to the Tools menu. This
works fine.

Type applicationType = applicationObje ct.GetType();
CommandBars bars = (CommandBars)ap plicationType.I nvokeMember(
"CommandBar s", BindingFlags.Ge tProperty, null, applicationObje ct,
null);
CommandBar bar = bars["Tools"];
Debug.WriteLine (bar.Name);

But the following more readable code throws "An unhandled exception of
type 'System.Executi onEngineExcepti on' occurred in testaddin.dll" on the
third line.

Excel.Applicati on app = (Excel.Applicat ion)application Object;
CommandBars bars = app.CommandBars ;
CommandBar bar = bars["Tools"];
Debug.WriteLine (bar.Name);

I have read Programming Office Applications Using Microsoft Visual C#
(http://msdn.microsoft.com/library/de.../OffCSharp.asp)
and the potential problem I see is "Handling Parameterized Properties
with Excel". But that doesn't seem applicable or the first version
wouldn't work correctly. What gives?

[Apurva Sinha \(MS\)]

"Russell Smith" <rlsmith @ caci dot com> wrote in message
news:OV******** ******@TK2MSFTN GP11.phx.gbl...

I checked references and worked around the problem but am not sure whether
this is the right approach. The default Shared Add-in project contains a
reference named "Office".

Description: <blank>
Identity: Office
Path: C:\WINDOWS\Micr osoft.NET\Frame work\v1.1.4322\ Office.dll

I noticed that the default VSTO Excel Workbook project contains a
reference named "Microsoft.Offi ce.Core".

Description: Microsoft Office 11.0 Object Library
Identity: {2DF8D04C-5BFA-101B-BDE5-00AA0044DE52}\2 .3\0\primary
Path:
C:\WINDOWS\asse mbly\GAC\Office \11.0.0.0__71e9 bce111e9429c\Of fice.dll

When I deleted the Add-In project's Office reference and replaced it with
the same reference used by the Excel Workbook project, it worked fine. I
have no idea which is the correct reference to use. Based on the DLL file
timestamps, the first was installed as part of Office 2003, the second was
installed as part of VSTO.

Please enlighten me.

V/R
Russell

"Nicholas Paldino [.NET/C# MVP]" <mv*@spam.guard .caspershouse.c om> wrote
in message news:%2******** *********@TK2MS FTNGP11.phx.gbl ...

Russel,

The only thing I can think of is that the version of excel that you
are testing your add in against is different than the version that the
interop library was generated for. Is this possible?
--
- Nicholas Paldino [.NET/C# MVP]
- mv*@spam.guard. caspershouse.co m

"Russell Smith" <rlsmith @ caci dot com> wrote in message
news:Oo******** *******@TK2MSFT NGP14.phx.gbl.. .

I am creating an Excel add-in. Please note project type is Shared Add-in
vice Excel Workbook. In the OnStartupComple te event handler I am adding
a new menu item. I start by getting a reference to the Tools menu. This
works fine.

Type applicationType = applicationObje ct.GetType();
CommandBars bars = (CommandBars)ap plicationType.I nvokeMember(
"CommandBar s", BindingFlags.Ge tProperty, null, applicationObje ct,
null);
CommandBar bar = bars["Tools"];
Debug.WriteLine (bar.Name);

But the following more readable code throws "An unhandled exception of
type 'System.Executi onEngineExcepti on' occurred in testaddin.dll" on the
third line.

Excel.Applicati on app = (Excel.Applicat ion)application Object;
CommandBars bars = app.CommandBars ;
CommandBar bar = bars["Tools"];
Debug.WriteLine (bar.Name);

I have read Programming Office Applications Using Microsoft Visual C#
(http://msdn.microsoft.com/library/de.../OffCSharp.asp)
and the potential problem I see is "Handling Parameterized Properties
with Excel". But that doesn't seem applicable or the first version
wouldn't work correctly. What gives?

Hey Russel,
The second reference is the right one. You can find it under the COM Tab of
the 'Add References' dialog in VS.
Description: Microsoft Office 11.0 Object Library
Identity: {2DF8D04C-5BFA-101B-BDE5-00AA0044DE52}\2 .3\0\primary
Path:
C:\WINDOWS\asse mbly\GAC\Office \11.0.0.0__71e9 bce111e9429c\Of fice.dll

As you said, this is the reference added to your project when you create a
VSTO project.

Hope this helps.
Apurva Sinha (MS)