Excel COM-AddIn and ActionsPane problem

[Rolando Tonin]

I wrote an Excel COM-AddIn in C# with many library functions to customize
and automation our worksheets modules. This C# libraries use
Microsoft.Office.Interop.Excel.Workbook object from COM-AddIn startup events
to fill worksheets.
Now I write an ActionsPane Project and I want to use this libraries for the
same work but the Globals.ThisWorkBook is an
Microsoft.Office.Tools.Excel.Workbook and this code:

(Microsoft.Office.Interop.Excel.Workbook) Globals.ThisWorkBook

don't work. What can I do?.

thanks for the answers

 

[Cindy M -WordMVP-]

Hi Rolando,

I wrote an Excel COM-AddIn in C# with many library functions to customize
and automation our worksheets modules. This C# libraries use
Microsoft.Office.Interop.Excel.Workbook object from COM-AddIn startup events
to fill worksheets.
Now I write an ActionsPane Project and I want to use this libraries for the
same work but the Globals.ThisWorkBook is an
Microsoft.Office.Tools.Excel.Workbook and this code:

(Microsoft.Office.Interop.Excel.Workbook) Globals.ThisWorkBook

don't work. What can I do?.

If suggestion below doesn't help, try asking this question here, the forum
dedicated to VSTO:

http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=16&SiteID=1&PageID=0

When you ask there, please give more details on how the code does not work.
What error messages are you getting? Are you trying to use this code to access
something in the libraries, or to address the workbook that's part of the
project?

If the latter, try instead:
this.InnserObject

that should return the workbook that's the basis of your VSTO project.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 17 2005)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or reply
in the newsgroup and not by e-mail