Microsoft.Office.Interop.Excel.ListObject vs Microsoft.Office.Tools.Excel.ListObject
- by Kavita A
I need to access the Selected Event of all the listobjects in all the worksheets of my workbook but when I access worksheet.listobject, that object apparently belongs to
Microsoft.Office.Interop.Excel.ListObject and so doesn't have any events where as the table list object belongs to Microsoft.Office.Tools.Excel.ListObject.
And I read that
Microsoft.Office.Tools.Excel.ListObject.InnerObject = Microsoft.Office.Interop.Excel.ListObject
but i don't know how to use it.
Pls Help
Thanks,
Kavita