1 / 9

Programming in the Office 2003 Environment

Programming in the Office 2003 Environment. Corinne Hoisington. Can I still use VBA?. Yes, but…. Doc will always open, even if the VBA code doesn’t run (not trusted) Office and Visual Studio combine to deliver power and productivity for robust, secure solutions

stacia
Télécharger la présentation

Programming in the Office 2003 Environment

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Programming in the Office 2003 Environment Corinne Hoisington

  2. Can I still use VBA? • Yes, but…. • Doc will always open, even if the VBA code doesn’t run (not trusted) • Office and Visual Studio combine to deliver power and productivity for robust, secure solutions • Visual Studio Tools for Office makes writing managed code behind Office documents as simple as File | New | Project

  3. MS Visual Studio Tools • Microsoft® Visual Studio Tools for the Microsoft Office System provides a new set of Visual Studio® .NET 2003 project templates you can use to create assemblies that run in process with Microsoft Office Excel 2003 and Microsoft Office Word 2003. This enables you to create document-centric solutions that utilize the power of the hosting application, which, in this first release, includes Excel and Word. Using either Microsoft Visual Basic® .NET or Microsoft Visual C#®

  4. VB.NET Coding

  5. Debugging • When developers want to test an application, they can simply click Start on the Visual Studio .NET toolbar. This starts up the Word document or Excel workbook and runs the custom code. Developers can then view the Word or Excel solution and observe the results of the running code. They can also set break points in the code and be returned to Visual Studio .NET for debugging purposes.

  6. Order of Installation • The order of product installation is important. On a developer's computer, Visual Studio .NET 2003 Professional or higher must be installed first. As part of its installation, Visual Studio installs version 1.1 of the Microsoft .NET Framework. The .NET Framework must be installed before Office 2003 to ensure that the global assembly cache (GAC) is available. The Office installation program installs the PIAs for the Office applications, including the necessary Word and Excel PIAs, into the GAC as part of the setup. So, the installation order is: • Microsoft Visual Studio .NET 2003 • Microsoft Office System • Visual Studio Tools for the Microsoft Office System

  7. New C#.NET • Microsoft Office Word and Microsoft Office Excel expose rich programming models, but those object models were originally written to be consumed by VBA clients. Visual Basic .NET, even with Option Strict On, can handle most of the requirements of the Office object models. Consuming those object models with C# requires a bit more care. When writing applications using Visual Studio Tools for the Microsoft Office System and C#, keep in mind that you'll often need to make concessions to the differences between the languages

  8. Access 2003 Programming • The Access 2003 Developer Extensions provide the tools and resources developers need to more quickly and easily create, test and deploy sophisticated Access solutions.

More Related