View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Raghu Raghu is offline
external usenet poster
 
Posts: 14
Default 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!