- Access Web Services in Excel Using Visual Studio Tools for the Microsoft Office System
Geoff Hill demonstrates how to integrate a stock information Web service into an Excel 2003 worksheet using Visual Studio Tools for the Microsoft Office System.
- Add XML Functionality in Excel 2003 from Visual Basic .NET
Discover how to generate XML from a dataset, format the XML using a Stylesheet, and then use code to open the transformed XML.
- Build a Professional Stock Allocation System Using Visual Studio Tools for Office, Version 2003
Learn how to work more efficiently by merging the rich user experience provided by Office 2003 with the enterprise-level development tools provided by Visual Studio 2003 and the .NET Framework 1.1.
- Call Visual Basic for Applications Code from Visual Basic .NET
Learn how to run VBA procedures in key Microsoft Office programs directly from Visual Basic .NET.
- Convert VBA Code to Visual Basic .NET
Read this article for a review of the major code conversion issues and the benefits of migrating your VBA code to Visual Basic .NET and Visual Studio 2005 Tools for Office.
- Create an End-to-End XML Solution with Word 2003 and Excel 2003
Frank Rice and Paul Cornell walk you through a simple end-to-end solution that demonstrates how XML has made it simple to move data from one Microsoft Office application to another.
- Create an Estimate Solution Using Visual Studio Tools for Office, Version 2005
Learn how a basic order entry system can use Excel 2003 for data entry, calculation, and charting capabilities and Word 2003 for the generation of a report. The download contains both a Visual Basic .NET and C# project.
- Create Charts in Excel 2003 Using Visual Basic for Applications Code
Frank Rice details methods of creating charts though the macro recorder, using Microsoft Visual Basic for Applications, and by using automation.
- Create Excel Solutions for Users in More than One Country or Region
Learn which issues you should consider when using Visual Studio Tools for Office to create Excel 2003 solutions for end users in more than one country or region.
- Create Smart Tags And Event-Code For AutoFilter Results
Learn how to use smart tags in an innovative way by making them respond to user filtering or sorting in worksheet.
- Create XML Mappings in Excel 2003
Walk through common XML tasks in Excel 2003 to learn more about the new XML functionality in Office 2003 Editions. Learn how to add custom schemas, work with XML maps in Excel, and create a series of mappings based on various schemas.
- Different Ways of Using Web Queries in Excel 2003
Frank Rice shows various ways to use Web queries to retrieve data from a Web page, including using static and dynamic queries as well as the Add and Find methods.
- Different Ways to Take Advantage of the E-mail Features of Excel
Excel MVP Ron de Bruin provides a number of samples and a handy add-in that enhances your experience when working with e-mail from Excel.
- Dynamic Managed Controls and Views in an Excel Solution
Use the .NET Framework in Visual Studio 2005 Beta 1 to utilize managed controls that present and navigate data in ways that Excel does not support out-of-the-box. (
- Edit XML Data with Word 2003 and Excel 2003
Mary Chipman shows how users can create and edit documents containing information marked by XML tags in a completely intuitive fashion without needing to learn or understand XML.
- Generate Excel Workbooks with Visual Basic and ASP
Learn different ways to use XML files and XML style sheets to create formatted Excel workbooks, such as using either ASP or Visual Basic to create Excel workbooks.
- Handy Tips for Working with Excel 2003
Make your applications more robust and provide more options for your users when you use and modify these tips from the Excel newsgroups. (
- How Excel 2003 Infers XSDs when Importing XML Data
Review the rules and instances where Excel 2003 infers schema from XML data during import and export. Understand why Excel creates the schemas it does and then learn to modify your own XML data.
- Import XML Maps, XML Lists, and Dynamic Chart Sources in Excel 2003
See how Microsoft Office Excel 2003 makes use of XML maps, XML lists, and new routines for importing XML to create a solution that enables a spreadsheet and chart to adapt to a user's data selection criteria.
- Integrate Word, Excel, and InfoPath with SQL Server 2000
Discover how new capabilities in Excel 2003, Word 2003, and InfoPath 2003 provide a variety of ways to connect to and interact with SQL Server data.
- Overview of Server Capabilities in Visual Studio Tools for Office, Version 2005
Learn about the powerful new server capabilities of Visual Studio Tools for Office, Version 2005 as you create a solution that uses Word 2003 and Excel 2003 on the server. (
- Part 1: Automating the XML Data Mapping Process in Excel 2003
Learn how to use XML maps to customize Excel as a data input and display system.
- Part 2: Mapping XML from SQL Server to a Single Cell in Excel 2003
In the second of this three-part series, learn how to map well-formed XML from a standard SQL Server query to a single cell in a worksheet. The resulting output is an XML tree with non-repeating elements.
- Part 3: Replicating Excel 2003 Formulas to SQL Server
In the third of a three-part series, learn how to use XML maps to automate a process for storing Excel 2003 formulas in a SQL Server database.
- Super-Easy Guide to the Microsoft Office Excel 2003 Object Model
Frank Rice shows how easy it is to use the Excel object model to customize the way you work with Excel. Lessons include creating subroutines, the basics of objects, methods, and properties, and using dialog boxes.
- Transfer XML Data to Excel 2003 with Visual Basic .NET
Learn different ways to transfer data from an Access database to Excel 2003. These include using the user-interface, programmatically creating an XML file, transforming the data and reading it into Excel, and automating Excel and programmatically reading the data file.
- Understanding the Excel Object Model from a .NET Developer's Perspective
Ken Getz discusses some of the objects provided by Microsoft Office Excel 2003 and explains how you can use them to create managed code solutions with Microsoft "Visual Studio Tools for Office."
- Unlocking Information in Microsoft Office 2003 Using XML
Explore a sample Web application built using ASP.NET that demonstrates how Microsoft Office documents can be processed and used external to the application that created them. (
- Use Smart Tags to Enable Data Drill-Down in Excel
You can use smart tags to reestablish the connection between data stored in spreadsheets with other data in your enterprise. Here's how.
- Use the Excel 2003 Object Model to Add XML Data Integration
Peter Vogel demonstrates using the Excel object model to take advantage of the XML support in Excel including namespaces, XML Lists, XML Maps, data binding and more.
- Using Schemas with Word 2003 and Excel 2003
Mary Chipman provides an easy to follow introduction for working with the new XML functionality in the Microsoft Office System by walking through common XML tasks in Word 2003 and Excel 2003.
- Using the Excel 2003 XML Tools Add-in
James Rivera and Frank Rice show how this new add-in makes working with XML maps, cells, and ranges much easier for developers.
- VBA Samples for Working with Excel 2003 Worksheets
Discover macros that you can use to add additional functionality to your Excel worksheets. With a little practice, you can extend these procedures to fit your own applications.
- Visual Studio 2005 Tools for Office Hands-on Labs for Excel 2003
Use these hands-on labs to gain experience in building an asset allocation application and a debt consolidation application using Visual Studio 2005 Tools for Office Beta 2 and Excel 2003.
- XML and Microsoft Office Excel 2003: Creating an Expense Report Template
Frank Rice explains how to reuse legacy forms and documents by taking advantage of some of the new features of Excel. This document discusses repeating and non-repeating XML data, creating Data Maps, and exporting data as XML.