Microsoft Office 2003 Editions: Overview of Developer TechnologiesSeptember 2004
Read the MSDN article "Understanding the Excel Object Model from a .NET Developer's Perspective":
Download and begin using the InfoPath 2003 Toolkit for Visual Studio .NET:
Learn to use XML functionality in Excel with Visual Basic .NET:
Learn how to consume ADO.NET Datasets in Office from Visual Studio:
Visual Studio Tools for the Microsoft Office System
Microsoft Visual Studio Tools for the Microsoft Office System is a new technology that brings the power and productivity of Visual Studio .NET and the Microsoft .NET Framework to business solutions built on Word and Excel. With this technology, using Visual Studio .NET 2003 and "Visual Studio 2005 (Beta)", you can use Visual Basic .NET and C# to write code behind Word and Excel documents. The following two sections review Visual Studio Tools for Office version 2003 and "Visual Studio Tools for Office version 2005 (beta)".
Visual Studio Tools for Office version 2003
You can use Visual Studio .NET and Visual Studio Tools for Office version 2003 to address any number of business scenarios requiring code to execute behind Word and Excel documents. These could involve business logic that manages budget figures in an Excel spreadsheet, or populating a table in a Word document with sales figures obtained using a Web service.
Businesses and developers have long benefited from the ability to use VBA to customize Office applications and integrate them with existing data and systems. While VBA continues to be an important part of Office development and benefits from the new features of Office 2003 Editions, Visual Studio Tools for Office version 2003 provides significant advances in the areas of language choice and innovation, security, deployment, and an integrated development environment (IDE).
With a Visual Studio Tools for Office version 2003 solution, the end-user receives rich, integrated functionality to use with their Word or Excel document. Although the feel of a Visual Studio Tools for Office version 2003 solution may be comparable to that of a Visual Basic for Applications (VBA) solution, the network deployment capability and security model help ensure that the end-user's desktop is secure and that the latest version of the solution is always used.
Visual Studio Tools for Office version 2003 allows you to build solutions using Visual Studio .NET 2003 that targets Word or Excel documents and templates in Office 2003 Editions. Visual Studio Tools for Office version 2003 provides full access to the Word and Excel object models, as well as the benefit of Microsoft IntelliSense® statement completion when you write code against these object models. You can compose code in Visual Basic .NET or C# that runs from the document or workbook and uses all areas of Visual Studio .NET, including the Server Explorer, Microsoft Windows Forms, ADO.NET data access, and Dynamic Help. Visual Studio
© 2006 Microsoft Corporation. All rights reserved. Page 25 By using or providing feedback on these materials, you agree to the attached license agreement.
To comment on this paper or request more documentation on these developer features, contact us at . We look forward to hearing from you.