ExcelTaskPane of Workbook

Add-in Express™ Support Service
That's what is more important than anything else

ExcelTaskPane of Workbook
 
Subscribe
Thomas Horstmann




Posts: 12
Joined: 2020-08-24
I have got a ExcelTaskPane with different buttons. When the user creates a new Excel workbook or opens one, a new instance of the ExcelTaskPane is created for the Excel workbook.

When the user clicks on a button on the TaskPane, I need to know which workbook is used by the button/TaskPane. I can check the index of "TaskPaneManager.Items[0].TaskPaneInstances". Is the instances-index equal to "ExcelApp.Workbooks.Items" (-1)? Is this the correct way, to find out the workbook?
Posted 22 Nov, 2022 11:15:06 Top
Andrei Smolin


Add-in Express team


Posts: 18413
Joined: 2006-05-11
Hello Thomas,

Get TadxExcelTaskPane.WindowObj and cast it to Excel Window.

Regards from Poland (GMT+1),

Andrei Smolin
Add-in Express Team Leader
Posted 23 Nov, 2022 04:31:23 Top