On the surface, it doesn't appear as if much in Excel 2003 has changed. There are a handful of new objects and the user interface is largely the same. But beyond a superficial glance, you'll see that there are fundamental shifts implied by the new features: Lists, XML, web services, .NET, and InfoPath build a framework for entirely new ways to exchange data with Excel. In fact, that's much of what Excel 2003 is all about--solving problems that deal with teamwork-- collecting and sharing data, programming across applications, and maintaining security. The latest in our Developer's Notebook series, this guide introduces intermediate to advanced Excel VBA programmers to the newest programming features of Excel 2003,--focusing just on what's new--so you can get up to speed quickly. Light on theory and long on practical application, the book takes you directly to the topics you'll want to master through a series of hands-on projects. With dozens of practical labs, you'll be able to decide for yourself which new aspects of Excel will be useful or not in your own work.
And best of all, you won't have to buy an expensive revision of a legacy Excel programming tutorial to learn about the new features--if they're covered there at all. Excel 2003 Programming: A Developer's Notebook shows you how to work with lists and XML data, secure Excel applications, use Visual Studio Tools for Office, consume Web Services, and collect data with Infopath. Each chapter is organized into a collection of labs, each of which addresses a specific programming problem. You can follow along to complete the lab on your own, or jump ahead and use the samples the author has built for you. The new Developer's Notebooks series from O'Reilly covers important new tools for software developers. Emphasizing example over explanation and practice over theory, they focus on learning by doing--you'll get the goods straight from the masters, in an informal and code-intensive style that suits developers. If you've been curious about Excel 2003, but haven't known where to start, this no-fluff, lab-style guide is the solution.
Auflage
Sprache
Verlagsort
Zielgruppe
Produkt-Hinweis
Broschur/Paperback
Klebebindung
Maße
Höhe: 234 mm
Breite: 177 mm
Dicke: 22 mm
Gewicht
ISBN-13
978-0-596-00767-6 (9780596007676)
Schweitzer Klassifikation
Jeff Webb has written about computers and technology for 20 years. His books include Using Excel Visual Basic for Applications; Visual Basic Developer's Workshop; and Developing Web Applications with Visual Basic .NET. He has also written programming guides, articles, and sample applications for Microsoft and Digital Equipment Corporation.
Preface Chapter 1. Program the New Excel Dude, Where's My Data? How the Pieces Fit Try It Kick-Start Lists and XML Kick-Start SharePoint Kick-Start Web Services Kick-Start Security and .NET Kick-Start InfoPath What Next? Chapter 2. Share Workspaces and Lists Get SharePoint Services Create a Shared Workspace Share a Workbook Open a Shared Workbook Display a SharePoint Site Remove Sharing Add Users and Permissions Allow Anonymous Users Create a List Share a List Update a Shared List Insert a Shared List Delete or Unlink a Shared List Use the Lists Web Service Chapter 3. Work with XML Speak XML XML Side-story Save Workbooks as XML Transform XML Spreadsheets Transform XML into a Spreadsheet Use XML Maps Exporting Through XML Maps Use Templates with XML Respond to XML Events Program with XML Maps Get an XML Map from a List or Range Chapter 4. Get Data from the Web Perform Web Queries Modify a Web Query Perform Periodic Updates Manage Web Queries Use Web Services Use the Web Services Toolkit Use Web Services Through XML Call a Web Service Asynchronously Reformat XML Results for Excel Chapter 5. Program Excel with .NET Work with .NET Create .NET Components Use .NET Components Respond to Errors and Events from .NET Debug .NET Components Distribute .NET Components Use Excel as a Component in .NET Work with Excel Objects in .NET Respond to Excel Events in .NET Respond to Excel Errors in .NET Distribute .NET Applications That Use Excel Create Excel .NET Applications Set .NET Security Policies Respond to Events in .NET Applications Debug Excel .NET Applications Display Windows Forms Distribute Excel .NET Applications Distribute Excel .NET Documents Migrate to .NET Chapter 6. Explore Security in Depth Dress in Layers Use Windows Security Password Protect and Encrypt Workbooks Program with Passwords and Encryption Protect Items in a Workbook Program with Protection Use Identity-Based Security (a.k.a. IRM) Program with Permissions Add Digital Signatures Set Macro Security Distribute Security Settings Common Questions Chapter 7. Build InfoPath Forms Are InfoPath Forms Better? InfoPath and Excel Share Data Link a Form to a Database Populate a Control from a Data Source Validate Data Link a Form to a Web Service Script InfoPath Program InfoPath in .NET Generate HTML Output Prevent Design Changes Index
