VSTO Excel AddIn Question
I am trying to create an Excel add-in using VSTO excel-adding project template.
The excel user would drag the elements from an xsd into an excel sheet in
order to create list objects. I believe these list objects would not be the
ones from Tools.Excel but only from Interop.Excel?
If so, in my c# code how do I get hold of the corresponding Tools.Excel's
ListObject for the list that the user created in excel?
Is there a complete sample that shows how to create the host controls when
an excel sheet is brought up (since close-and-reopen does not save the vsto's
controls?).
From ThisAddIn_Startup's Application object how do I get the worksheet
object host item?
Thanks for your reply!
|