MSDN Articles

Developing Add-ins (XLLs) in Excel 2007
2002: Building Excel Real-Time Data Components in Visual Basic .NET
2002: Building a Real-Time Data Server in Excel 2002
2002: Real-Time Data: Frequently Asked Questions


MSDN > Office Client Development - Excel 2013

What's new for Excel 2013 developers


MSDN > Office Client Development - Excel 2010

Creating Excel 2010 Bubble Charts for Use with Excel Services
Creating PivotTable Reports and Charts with VBA in Excel 2010
Creating Popup Menus in All Versions of Excel
Customizing Context Menus in All Versions of Microsoft Excel
Enabling Write-back to an OLAP Cube at Cell Level in Excel 2010
Excel 2010 Performance: Improving Calculation Performance
Excel 2010 Performance: Performance and Limit Improvements
Excel 2010 Performance: Tips for Optimizing Performance Obstructions
Exploring PowerPivot for Excel and SharePoint: Blue Yonder Charters
Generating Excel 2010 Workbooks by using the Open XML SDK 2.0
Getting Started with VBA in Excel 2010
Merging Data from Multiple Workbooks into a Summary Workbook in Excel 2011 for the Mac
Performing File and Folder Operations Programmatically in Excel 2011 for the Mac
Programmatically Selecting Files in Excel for Windows and Excel for the Mac
Running VBA Code When Events Occur in Excel 2010
Understanding the Excel .xls Binary File Format
Using Custom Data Parts in Excel 2010
Using Worksheet Functions from VBA Code in Excel 2010
Working with the Compatibility Checker in Excel 2007 and Excel 2010


MSDN > Office Client Development - Excel 2007

Adding Color to Excel 2007 Worksheets by Using the ColorIndex Property
Animating Objects in Excel 2007 Using the 3-D Animation Engine
Building Excel 2007 and Excel Services Dashboards by Consuming Two-Dimensional Data from Web Services
Calling Excel 2007 Custom Wizards from the Office Fluent Ribbon by Using VBA
Consolidating Data from Multiple Worksheets into a Summary Worksheet in Excel
Creating Custom Ribbon Galleries in Excel 2007
Creating VBA Macros to Manipulate Worksheets in Excel 2007
Developing Add-ins (XLLs) in Excel 2007
Developers Guide to the Excel 2007 Application Object
Developers Guide to the Excel 2007 Range Object
Editing Data in an Excel 2007 Open XML File with VBA
Filtering Data Programmatically in Excel 2007 by Using PivotTables
Implementing Week-Numbering Systems and Date/Time Representations
Improving Performance in Excel 2007
Merging Data from Multiple Workbooks into a Summary Workbook in Excel
Using Styles to Dress Up Your Worksheets in Excel 2007


MSDN > Office Client Development - Excel 2003

Add XML Functionality in Microsoft Office Excel 2003 from Microsoft Visual Basic .NET
Creating Charts in Excel 2003 Using Visual Basic for Applications Code
Creating XML Mappings in Excel 2003
Different Ways to Take Advantage of the E-mail Features of Excel
Different Ways of Using Web Queries in Microsoft Office Excel 2003
Handy Tips for Working with Excel 2003
How Excel 2003 Infers XSDs When Importing XML Data
Importing XML Maps XML Lists and Dynamic Chart Sources in Excel 2003
Microsoft Office Excel 2003 Preview
Part 1: Automating the XML Data Mapping Process in Excel 2003
Part 2: Mapping XML from SQL Server to a Single Cell in Excel 2003
Part 3: Replicating Excel 2003 Formulas to SQL Server
Populating an Excel 2003 Worksheet with Multiple Related Records from a Windows Form
Super-Easy Guide to the Microsoft Office Excel 2003 Object Model
Transfer XML Data to Microsoft Office Excel 2003 with Microsoft Visual Basic .NET
Understanding Security for Add-ins and VBA Macros in Excel 2003
Use Smart Tags to Enable Data Drill-Down in Excel
Using the Excel 2003 Object Model to Add XML Data Integration
Using the Excel 2003 XML Tools Add-in Version 1.1
Using the Excel XML Toolbox for Microsoft Office Excel 2003
Using Visual Basic and ASP with XML to Generate Excel 2003 Workbooks
VBA Samples for Working with Excel 2003 Worksheets
XML and Microsoft Office Excel 2003: Creating an Expense Report Template
Chapter 20: Creating Advanced User Forms


MSDN > Office Client Development - Excel 2002

Building Excel Real-Time Data Components in Visual Basic .NET]
Building a Real-Time Data Server in Excel 2002
Connecting to a Managed Component from Excel 2002 Visual Basic for Applications
Creating Smart Tags and Event-Code for AutoFilter Results
Distributing Enterprise Data via XML with SQL Server 2000 and Excel 2002
Extending Excel OLAP Functionality
Five Handy Charting Tips for Excel Developers (May 2003)
Just What Are Cubes Anyway? (A Painless Introduction to OLAP Technology)
OLAP Related Features in Microsoft Excel 2002 and the Microsoft Office XP Web Components
Programming Microsoft Word 2002 and Excel 2002 with Microsoft Visual C#
Real-Time Data: Frequently Asked Questions
Recalculation in Microsoft Excel 2002
Transform XML Files with XSLT When Importing into Microsoft Excel 2002
Using the ErrorCheckingOptions and Watch Objects to Ensure the Accuracy of Spreadsheets
Using Microsoft Excel 2002 and Microsoft BizTalk Server To Build B2B Solutions
Using Microsoft Excel 2002 with SQL Server Analysis Services
Using the Protection Object to Protect Your Worksheets
Web Queries and Dynamic Chart Data in Excel 2002
XML in Excel and the Spreadsheet Component
XML Spreadsheet Reference
XML Web Service-Enabled Office Documents
Chapter 5: Using Ranges


© 2017 Better Solutions Limited. All Rights Reserved. © 2017 Better Solutions Limited

Prev