PageRenderTime 42ms CodeModel.GetById 35ms app.highlight 2ms RepoModel.GetById 1ms app.codeStats 0ms

/Visual Studio 2008/VBVstoExcelWorkbook/Readme.txt

#
Plain Text | 44 lines | 28 code | 16 blank | 0 comment | 0 complexity | ff5684cb8375c51aa091938f02e7620d MD5 | raw file
 1========================================================================
 2    EXCEL WORKBOOK : VBVstoExcelWorkbook Project Overview
 3========================================================================
 4
 5/////////////////////////////////////////////////////////////////////////////
 6Use:
 7
 8The VBVstoExcelWorkbook provides the examples on how to customize Excel 
 9Workbooks by using the ListObject and the document Actions Pane. 
10
11
12/////////////////////////////////////////////////////////////////////////////
13Prerequisites:
14
15The code sample requires Microsoft Excel 2007.
16
17
18/////////////////////////////////////////////////////////////////////////////
19Creation:
20
21Actions Pane
22
231. Create a User Control named CourseQueryPane.
242. In ThisWorkbook class, add the User Control to the Actions Pane using the
25   following code:
26   
27   this.ActionsPane.Controls.Add(new CourseQueryPane());
28   
29List Object
30
311. Drag & drop a ListObject from the Toolbox onto Sheet1.
322. Set the DataSource property of the ListObject.
333. At runtime, update related tables and the ListObject will reflect the data.
34
35/////////////////////////////////////////////////////////////////////////////
36References:
37
38ListObject Class:
39http://msdn.microsoft.com/en-us/library/microsoft.office.tools.excel.listobject.aspx
40
41ActionsPane Class:
42http://msdn.microsoft.com/en-us/library/microsoft.office.tools.actionspane.aspx
43
44/////////////////////////////////////////////////////////////////////////////