Sample Download : http://code.msdn.microsoft.com/VBVstoExcelWorkbook-c5ecb0ea
The VBVstoExcelWorkbook provides the examples on how to customize Excel Workbooks by using the ListObject and the document Actions Pane.
The Microsoft.Office.Interop.Excel.Workbook class represents a single workbook within the Excel application. Visual Studio Tools for Office extends the Microsoft.Office.Interop.Excel.Workbook class by providing the Microsoft.Office.Tools.Excel.Workbook class (http://msdn.microsoft.com/en-us/library/microsoft.office.tools.excel.workbook(v=vs.80).aspx), which gives you access to all members of the Workbooks collection (http://msdn.microsoft.com/en-us/library/microsoft.office.interop.excel.workbooks.aspx), as well as data binding capabilities and additional events.
Every document-level customization for Excel or Word exposes an ActionsPane object. You can use this object to customize the user interface of the Document Actions task pane in a document-level project. To get the ActionsPane object, use the ActionsPane field of the ThisDocument class (for Word) or the ThisWorkbook class (for Excel) in your project. For more information, see Actions Pane Overview(http://msdn.microsoft.com/en-us/library/7we49he1.aspx).
You can find more code samples that demonstrate the most typical programming scenarios by using Microsoft All-In-One Code Framework Sample Browser or Sample Browser Visual Studio extension. They give you the flexibility to search samples, download samples on demand, manage the downloaded samples in a centralized place, and automatically be notified about sample updates. If it is the first time that you hear about Microsoft All-In-One Code Framework, please watch the introduction video on Microsoft Showcase, or read the introduction on our homepage http://1code.codeplex.com/.