You are previewing Excel 2003 Programming: A Developer's Notebook.
O'Reilly logo
Excel 2003 Programming: A Developer's Notebook

Book Description

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.

Table of Contents

  1. Excel 2003 Programming: A Developer’s Notebook
    1. The Developer’s Notebook Series
      1. Notebooks Are...
      2. Notebooks Aren’t...
      3. Organization
    2. Preface
      1. Don’t Force It
      2. Get the Samples
      3. Font Conventions
      4. How to Contact Us
      5. Acknowledgments
    3. 1. Program the New Excel
      1. Dude, Where’s My Data?
      2. How the Pieces Fit
      3. Try It
      4. Kick-Start Lists and XML
      5. Kick-Start SharePoint
      6. Kick-Start Web Services
      7. Kick-Start Security and .NET
      8. Kick-Start InfoPath
      9. What Next?
    4. 2. Share Workspaces and Lists
      1. Get SharePoint Services
        1. How to do it
        2. How it works
        3. What about...
      2. Create a Shared Workspace
        1. How to do it
        2. How it works
      3. Share a Workbook
        1. How to do it
        2. How it works
      4. Open a Shared Workbook
        1. How to do it
        2. How it works
      5. Display a SharePoint Site
        1. How to do it
        2. How it works
        3. What about...
      6. Remove Sharing
        1. How to do it
        2. How it works
        3. What about...
      7. Add Users and Permissions
        1. How to do it
        2. How it works
        3. What about...
      8. Allow Anonymous Users
        1. How to do it
        2. How it works
        3. What about...
      9. Create a List
        1. How to do it
        2. How it works
      10. Share a List
        1. How to do it
        2. How it works
      11. Update a Shared List
        1. How to do it
        2. How it works
      12. Insert a Shared List
        1. How to do it
        2. How it works
      13. Delete or Unlink a Shared List
        1. How to do it
        2. How it works
        3. What about...
      14. Use the Lists Web Service
        1. How to do it
        2. How to add attachments to a list
        3. How to retrieve attachments
        4. How to delete attachments
        5. How to perform queries
        6. What about...
    5. 3. Work with XML
      1. Speak XML
        1. How it works
        2. What about...
      2. XML Side-story
        1. How it works
        2. What about...
      3. Save Workbooks as XML
        1. How to do it
        2. How it works
        3. What you lose and how to keep it
        4. What about...
      4. Transform XML Spreadsheets
        1. How to do it
        2. How to create XSLT
        3. How to transform in code
        4. How to transform from the command line
        5. How to transform in the browser
        6. How it works
        7. How to reset file associations
        8. What about...
      5. Transform XML into a Spreadsheet
        1. How to do it
        2. How it works
        3. What about...
      6. Use XML Maps
        1. How it works
        2. What you lose and how to keep it
        3. How it works
        4. Manage XML Maps
      7. Exporting Through XML Maps
        1. How it works
        2. What this means
          1. Avoid lists of lists
          2. Avoid denormalized data
          3. Create an XML schema
          4. Include all nodes if exporting
          5. Other things to avoid
      8. Use Templates with XML
        1. How to do it
        2. How it works
        3. What about...
      9. Respond to XML Events
        1. How to do it
        2. How it works
      10. Program with XML Maps
        1. How to add or delete XML maps
        2. How to export/import XML
        3. How to refresh/change/clear data
        4. How to view the schema
      11. Get an XML Map from a List or Range
        1. How to bind XML to a list column
        2. How to remove a binding
    6. 4. Get Data from the Web
      1. Perform Web Queries
        1. How to do it
        2. How it works
      2. Modify a Web Query
        1. How to do it
        2. How it works
      3. Perform Periodic Updates
        1. How to do it
        2. How it works
      4. Manage Web Queries
        1. How to do it
      5. Use Web Services
        1. Queries versus services
        2. How it works
        3. Where to get it
      6. Use the Web Services Toolkit
        1. How to do it
        2. How it works
        3. What about...
      7. Use Web Services Through XML
        1. How to do it
        2. How it works
        3. What about...
      8. Call a Web Service Asynchronously
        1. How to do it
        2. How it works
        3. What about...
      9. Reformat XML Results for Excel
        1. How to do it
        2. How it works
    7. 5. Program Excel with .NET
      1. Work with .NET
        1. What you need
        2. Where to get it
      2. Create .NET Components
        1. How to do it
        2. What about...
      3. Use .NET Components
        1. How to do it
        2. How it works
      4. Respond to Errors and Events from .NET
        1. How to do it
        2. How it works
      5. Debug .NET Components
        1. How to do it
      6. Distribute .NET Components
        1. How to do it
        2. How it works
      7. Use Excel as a Component in .NET
        1. How to do it
        2. How it works
      8. Work with Excel Objects in .NET
        1. How to do it
        2. What about...
      9. Respond to Excel Events in .NET
        1. How to do it
      10. Respond to Excel Errors in .NET
        1. How it works
        2. What this means
        3. What about...
      11. Distribute .NET Applications That Use Excel
        1. How to do it
        2. What about...
      12. Create Excel .NET Applications
        1. How to do it
        2. How it works
        3. What about...
      13. Set .NET Security Policies
        1. How to do it
        2. What about...
      14. Respond to Events in .NET Applications
      15. Debug Excel .NET Applications
      16. Display Windows Forms
        1. How to do it
        2. How it works
      17. Distribute Excel .NET Applications
        1. How to do it
      18. Distribute Excel .NET Documents
      19. Migrate to .NET
        1. What you lose: edit and continue
        2. Be explicit!
        3. Pass arguments by value
        4. Collections start at zero
        5. Data access is through ADO.NET
        6. What about...
    8. 6. Explore Security in Depth
      1. Dress in Layers
      2. Use Windows Security
        1. How to set file permissions in Windows XP
        2. How to view users and groups in XP
        3. What about...
      3. Password Protect and Encrypt Workbooks
        1. How to do it
        2. How secure are Excel Passwords?
        3. What about...
      4. Program with Passwords and Encryption
        1. How to do it
        2. How it works
        3. What about...
      5. Protect Items in a Workbook
        1. How to do it
        2. How it works
      6. Program with Protection
        1. How to do it
        2. How it works
        3. How to get Protection properties
        4. How to add an edit range
        5. How to add users
        6. What about...
      7. Use Identity-Based Security (a.k.a. IRM)
        1. How it works
        2. How IRM compares
        3. How to do it
        4. How it works
        5. What about...
      8. Program with Permissions
        1. How to do it
        2. What about...
      9. Add Digital Signatures
        1. Get a Digital Certificate
        2. Sign Code
        3. Sign Workbooks
        4. What about...
      10. Set Macro Security
        1. How to do it
        2. How to distribute macros
        3. How to set ActiveX control security
      11. Distribute Security Settings
        1. Use the Install/Maintenance Wizards
        2. Distribute certificates
        3. What about...
      12. Common Questions
        1. What is partial trust?
        2. What is the Office Anti-Virus API?
        3. How do you get rid of the macro security warning?
        4. How do you prevent all macros?
        5. How do you secure a workbook?
        6. How do you add a trusted publisher for a group of users?
    9. 7. Build InfoPath Forms
      1. Are InfoPath Forms Better?
        1. Where to get it
        2. What about...
        3. How to do it
        4. How it works
        5. Some terminology
        6. What about...
      2. InfoPath and Excel
        1. Link Excel to InfoPath through lists
        2. Start InfoPath from Excel
        3. What about...
      3. Share Data
        1. How to merge multiple files
        2. How to use Submit
        3. How to submit via email
        4. What about...
      4. Link a Form to a Database
        1. How to do it
        2. How it works
        3. What you can’t submit
        4. What about...
      5. Populate a Control from a Data Source
        1. How to do it
        2. How it works
      6. Validate Data
        1. How to do it
        2. How it works
      7. Link a Form to a Web Service
        1. How to do it
        2. How it works
        3. What about...
      8. Script InfoPath
        1. How to do it
        2. Why use script?
        3. Common script tasks
          1. Display a simple message box
          2. Save form data
          3. Send form data as an email attachment
          4. Get a value from a control
          5. Set a value of a control
          6. Get a form’s XML data
          7. Submit data
          8. Refresh secondary data sources
          9. Switch form views
          10. Display an HTML page
          11. Create a new form based on current template
          12. Create a new form based on a new template
          13. Open an existing form
          14. Quit InfoPath
        4. Debug and deploy
        5. What about...
      9. Program InfoPath in .NET
        1. Get the InfoPath .NET Toolkit
        2. How to do it
        3. How it works
        4. Debug and deploy
        5. What about...
      10. Generate HTML Output
        1. How to do it
        2. How it works
        3. What about...
      11. Prevent Design Changes
        1. How to enable protection
        2. How to disable design mode
    10. Index
    11. Colophon