Excel 2007 DevelopmentFind articles, references, code samples, and how-to videos for customizing Microsoft Excel 2007.
Book Excerpts
Code Samples
| Excel Forums |
.gif)
.png)
.png)
Tools and Utilities
- IMsoDocExporter Header File
Developers can use this interface to provide alternate add-ins for PDF or XPS or to provide an add-in for some other fixed-format document format.
- Add-in: Synchronizing Tables with SharePoint Lists
Synchronize data in an Excel 2007 table with a list on a SharePoint site.
- TCID and TBID Command Tables for Excel 2007 and Word 2007
Download Excel-versions of the TCID and TBID Command Tables for Excel 2007 and Word 2007.
Visual How Tos
.jpg)
Visual how-to content combines a short video, sample code, a conceptual overview, and links to related resources in a single user experience.
|
Articles
Excel 2007
- Adding Color to Excel 2007 Worksheets by Using the ColorIndex Property
- Animating Objects in Excel 2007 Using the 3-D Animation Engine
- Bringing Improvements to Tables in Excel 2007, Part 1
- Bringing Improvements to Tables in Excel 2007, Part 2
- Bringing Improvements to Tables in Excel 2007, Part 3
- Bringing Improvements to Tables in Excel 2007, Part 4
- Bringing Improvements to Tables in Excel 2007, Part 5
- Bringing Improvements to Tables in Excel 2007, Part 6
- Calling Excel 2007 Custom Wizards from the Office Fluent Ribbon by Using VBA
- Conditional Formatting: Adding Custom Conditional Formatting to Excel 2007
- Conditional Formatting: Adding Customized Color Scales to Excel 2007
- Conditional Formatting: Adding Customized Data Bars to Excel 2007
- Conditional Formatting: Adding Customized Icon Sets to Excel 2007
- Conditional Formatting: Adding Customized Rules to Excel 2007
- Connecting PivotTables in Excel 2007 to Data Stored in SharePoint Lists
- Consolidating Data from Multiple Worksheets into a Summary Worksheet in Excel 2007
- Creating and Sending PDF Files from Excel 2007 and Excel 2010
- Creating Custom Ribbon Galleries in Excel 2007
- Connecting PivotTables in Excel 2007 to Data Stored in SharePoint Lists
- Creating VBA Macros to Manipulate Worksheets in Excel 2007
- Customizing Context Menus in All Versions of Microsoft Excel
- Designing SQL Server 2005 Analysis Services Cubes for Excel 2007 PivotTables
- Developing Add-ins (XLLs) in Excel 2007
- Developers Guide to the Excel 2007 Application Object
- Developers Guide to the Excel 2007 Range Object
- Display a List of All VBA Procedures in a Workbook from the Ribbon (Office Talk Column)
- Display and Hide Tabs, Groups, and Controls on the Microsoft Office Ribbon, Part 2
- Editing Data in an Excel 2007 Open XML File with VBA
- Extending Word 2007, Excel 2007, and PowerPoint 2007 with a Single Line of VBA Code
- Filtering by the Active Cell's Value, Font Color, or Fill Color in Excel 2007
- Implementing Week-Numbering Systems and Date/Time Representations in Excel 2007
- Improving Performance in Excel 2007
- Interacting with the Excel Web Services API for SharePoint Server 2007
- Let's Get Connected in Excel 2007
- Merging Data from Multiple Workbooks into a Summary Workbook in Excel
- Two Methods for Importing Your Zune Playlist into Excel, Part 1
- Two Methods for Importing Your Zune Playlist into Excel, Part 2
- Understanding the Excel MS-XLS Binary File Format
- Using Styles to Dress Up Your Worksheets in Excel 2007
- Using VBA in Excel to Send Workbooks and Ranges Through E-Mail with Outlook, Part 1
- Using VBA in Excel to Send Workbooks and Ranges Through E-Mail with Outlook, Part 2
- Using VBA to Format Long Documents in the 2007 Office System in a Fraction of the Time
- Working with Active Accessibility in the 2007 Office Fluent User Interface
- Working with Excel Workbooks and Worksheets in E-Mail
- Working with Lists and Tables in Excel 2007: VBA Samples, Part 1
- Working with Lists and Tables in Excel 2007: VBA Samples, Part 2
- Working with the Compatibility Checker in Excel 2007 and Excel 2010
Managed Code
- Building Excel 2007 and Excel Services Dashboards by Consuming Two-Dimensional Data from Web Services
- Connecting PivotTables in Excel 2007 to Data Stored in SharePoint Lists
- Filtering Data Programmatically in Excel 2007 by Using PivotTables
- Importing Project 2007 Tasks from Excel 2007 Using a Managed Code Add-In
- Integrating Visio 2007 and Excel 2007
- Interacting with the Excel Web Services API for SharePoint Server 2007
- Introducing the Open XML Format External File Converter for 2007 Microsoft Office System SP2
- Manipulating Excel 2007 and PowerPoint 2007 Files with the Open XML Object Model, Part 1
- Manipulating Excel 2007 and PowerPoint 2007 Files with the Open XML Object Model, Part 2
- Programmatically Update Multiple External Data Connections in Excel 2007 by Using Open XML
- Publishing and Synchronizing Excel 2007 Tables to SharePoint Lists
- Test Run: Using Excel For Test Data
Videos
- Connecting PivotTables in Excel 2007 to Data Stored in SharePoint Lists
- Extending Word 2007, Excel 2007, and PowerPoint 2007 with a Single Line of VBA Code
- Using VBA to Access Document Content in the 2007 Office System
- Working with the Compatibility Checker in Excel 2007 and Excel 2010
- Excel 2007 Videos on YouTube
- Excel 2007 Videos on Channel 9
- BI302—Excel 2007: Building Business Intelligence Solutions Using Excel and SQL Server 2005 Analysis Services
- BI303—Developing User Defined Functions for Excel 2007 and Excel Services
