Excel Automation Add-In, Accessing the application object
 

I am currently moving a VB6 Excel add-in(xla) over to a C# Automation
Add-In(dll). The previous code used Application.StatusBar to access and
manipulate the text in the status bar. How can this be done in my C# add-in?
Thanks.

Note: The only example i saw of accessing the Excel application was using
the following line:
object oName =
applicationObject.GetType().InvokeMember("Name",Bi ndingFlags.GetProperty,null,applicationObject,null );

Excel Automation Add-In, Accessing the application object
 

"smedcalf" wrote in message
...
I am currently moving a VB6 Excel add-in(xla) over to a C# Automation
Add-In(dll). The previous code used Application.StatusBar to access and
manipulate the text in the status bar. How can this be done in my C#
add-in?
Thanks.

Note: The only example i saw of accessing the Excel application was using
the following line:
object oName =

applicationObject.GetType().InvokeMember("Name",Bi ndingFlags.GetProperty,nul
l,applicationObject,null);

The application object is passed to your add-in if you create a COM add-in.
This means you have to implement the IDTExtensibility2 interface.

http://msdn.microsoft.com/library/de...2Interface.asp

Best Regards,
Fredrik