View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
cybertof cybertof is offline
external usenet poster
 
Posts: 3
Default Office C# code behin : CommandBar Class Problem ?

Hello,

Could you please tell me what's wrong with this code
(c# office code behind) :


protected void ThisWorkbook_Open()
{
try
{
MessageBox.Show(ThisApplication.CommandBars.ToStri ng());
MessageBox.Show(ThisApplication.CommandBars.Count. ToString());
}
catch (Exception e)
{
MessageBox.Show(e.Message);
}
}



The first MessageBox works well and says
'Microsoft.Office.Core.CommandBarsClass'

But the 2nd MessageBox fails in
'Object Reference not set to an instance of an Object'


How to get number of command bars ?


Note :
When you create a new 'Excel C#' project,
is it normal that the wizard ommits the 'office' reference
(which include the Microsoft.Office.Core namespace...)