"Visual Studio 2005 Tools for Office IntelliSense Code Snippets"

Download details: Visual Studio 2005 Tools for Office IntelliSense Code Snippets

"IntelliSense code snippets allow developers to easily create and distribute their own customized code libraries. Using the Visual Studio Integrated Development Environment and the power of IntelliSense, inserting these commonly used pieces of code is an effective way to enhance your productivity.

The sample IntelliSense code snippets for Visual Studio 2005 Tools for the Microsoft Office System contained in this download provide a jump start for implementation of common Microsoft Office Word 2003 and Microsoft Office Excel 2003 solution development tasks in Microsoft Visual Studio 2005. The snippets facilitate development of general Microsoft Office environment manipulation including data importing/export, collaboration, and integration with Excel and Word controls.

The associated MSDN article discusses how to install and use IntelliSense code snippets. The download contains IntelliSense code snippets for both Visual Basic and C#."

Here's a simple list of all the snippet's...

Excel\Add chart as new worksheet
Excel\Add chart at named range
Excel\AutoFit column width to data
Excel\Bind named range to XML map value
Excel\BindListObjectContentsToDataSource
Excel\ConvertManualSelectionToArray
Excel\ConvertNamedRangeToDataSetAndSaveToFile
Excel\ConvertUsedRangeToXML
Excel\CreateListObjectControlByRange
Excel\CreateNamedRangeControlByRange
Excel\CreateOLAPPivotTableAtNamedRange
Excel\DisplayBuiltInExcelDialog
Excel\GetReferenceToEmbeddedChart
Excel\Hide or show specified columns
Excel\ImportAllDatabaseColumnsToNewSheet
Excel\ImportDelimitedTextFileToWorksheet
Excel\ImportToChartFromNamedRange
Excel\ImportXMLToSchemaMap
Excel\Protect worksheet
Excel\Shade alternate rows or columns
Excel\Unprotect worksheet
Excel\UseBuiltInExcelWorksheetFunction
Office\AddChildCommandActionOrButtonTo ParentCommand
Office\AddChildCommandMenuToParentCommand
Office\AddUserControlToActionsPane
Office\ChangeActionsPaneOrientation
Office\ChangeStackConfigurationInActionsPane
Office\DisableItemInStandardExcelMenu
Office\DisableItemInStandardWordMenu
Office\GetCachedDataItem
Office\GlobalizationHandlingForInteropCalls
Office\HideItemInStandardExcelMenu
Office\HideItemInStandardWordMenu
Office\InsertTypedDataSetIntoDataIsland
Office\InspectCachedDataManifest
Office\InstantiateServerDocumentFromFile
Office\ReadDataFromCachedDataItem
Office\RemoveUserControlFromActionsPane
Office\Reset command bars to original configuration
Office\Restore hidden menus to visible
Office\SaveAndCloseServerDocument
Word\Add an XML node to a document
Word\Add an XML schema to the schema library and attach to document
Word\Add header and footer auto text entry
Word\AddBookmarkControlToDocumentAtRange
Word\Change the text in an XML node in a document
Word\ChangeCommonTextFormattingOptionsOnRange
Word\Create new document based on template
Word\CreateAndSetDocumentVariable
Word\CreateTableWithSpecificDimensions And Formatting AndI nsert At Selection Point
Word\Delete an XML node and its contents from a document
Word\DeleteDocumentVariable
Word\FindAllParagraphsInAParticularStyleAnd ChangeTo New Style
Word\ImportAllDatabaseColumnsAndCreateTableAtBookmark
Word\ImportEntireExcelWorkbookStartingPasteAtSelection
Word\ImportEntireWordDocumentAndPlaceAtExistingBookmark
Word\Insert a date at bookmark
Word\Insert paragraph at bookmark
Word\Insert symbol at bookmark
Word\Insert text and date into a footer
Word\Insert text and date into a header
Word\Loop through all controls in a document and set a property such as enabled
Word\Manually validate an XML node in a document
Word\Print current page on default printer without prompting
Word\ReadDocumentVariable
Word\Set the validation error message for an XML node
Word\SetCommonPageSetupOptions
Word\ShowBuiltInWordDialog
Word\Toggle spell and grammar checkers on and off
Word\Update table of contents
Word\Validate a document against the XML schema and display errors