ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   VSTO Excel AddIn Question (https://www.excelbanter.com/excel-programming/384680-vsto-excel-addin-question.html)

Raghu

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!



All times are GMT +1. The time now is 06:12 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com