Have Geek Brain

Microsoft.Office.Interop.Excel.ListObject vs Microsoft.Office.Tools.Excel.ListObject

I need to access the selected event of all list objects in all sheets of my workbook, but when I access the .listobject worksheet, this object appears to be owned by Microsoft.Office.Interop.Excel.ListObject and therefore doesn't have any or events when a table list object is owned by Microsoft.Office.Tools.Excel.ListObject.

And I read that Microsoft.Office.Tools.Excel.ListObject.InnerObject = Microsoft.Office.Interop.Excel.ListObject

but i dont know how to use it.

Pls help

Thank you, Kavita p>

+2


a source to share


1 answer


I think you should use Microsoft.Office.Tools.Excel.ListObject.GetVstoObject (lstObj) where lstObj is Microsoft.Office.Interop.Excel.ListObject to get the correct object. And it is only available at the Addin Application Level, not the Document-Level, you can read the documentation. From: MSDN info . And now you also have ListObjectExtensions



More information on Tools.Excel.ListObject events at: MSDN Events

+2


a source






More articles:


All Articles