1. Chapter 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?

2. Chapter 2 Share Workspaces and Lists

   1. Get SharePoint Services

   2. Create a Shared Workspace

   3. Share a Workbook

   4. Open a Shared Workbook

   5. Display a SharePoint Site

   6. Remove Sharing

   7. Add Users and Permissions

   8. Allow Anonymous Users

   9. Create a List

   10. Share a List

   11. Update a Shared List

   12. Insert a Shared List

   13. Delete or Unlink a Shared List

   14. Use the Lists Web Service

3. Chapter 3 Work with XML

   1. Speak XML

   2. XML Side-story

   3. Save Workbooks as XML

   4. Transform XML Spreadsheets

   5. Transform XML into a Spreadsheet

   6. Use XML Maps

   7. Exporting Through XML Maps

   8. Use Templates with XML

   9. Respond to XML Events

   10. Program with XML Maps

   11. Get an XML Map from a List or Range

4. Chapter 4 Get Data from the Web

   1. Perform Web Queries

   2. Modify a Web Query

   3. Perform Periodic Updates

   4. Manage Web Queries

   5. Use Web Services

   6. Use the Web Services Toolkit

   7. Use Web Services Through XML

   8. Call a Web Service Asynchronously

   9. Reformat XML Results for Excel

5. Chapter 5 Program Excel with .NET

   1. Work with .NET

   2. Create .NET Components

   3. Use .NET Components

   4. Respond to Errors and Events from .NET

   5. Debug .NET Components

   6. Distribute .NET Components

   7. Use Excel as a Component in .NET

   8. Work with Excel Objects in .NET

   9. Respond to Excel Events in .NET

   10. Respond to Excel Errors in .NET

   11. Distribute .NET Applications That Use Excel

   12. Create Excel .NET Applications

   13. Set .NET Security Policies

   14. Respond to Events in .NET Applications

   15. Debug Excel .NET Applications

   16. Display Windows Forms

   17. Distribute Excel .NET Applications

   18. Distribute Excel .NET Documents

   19. Migrate to .NET

6. Chapter 6 Explore Security in Depth

   1. Dress in Layers

   2. Use Windows Security

   3. Password Protect and Encrypt Workbooks

   4. Program with Passwords and Encryption

   5. Protect Items in a Workbook

   6. Program with Protection

   7. Use Identity-Based Security (a.k.a. IRM)

   8. Program with Permissions

   9. Add Digital Signatures

   10. Set Macro Security

   11. Distribute Security Settings

   12. Common Questions

7. Chapter 7 Build InfoPath Forms

   1. Are InfoPath Forms Better?

   2. InfoPath and Excel

   3. Share Data

   4. Link a Form to a Database

   5. Populate a Control from a Data Source

   6. Validate Data

   7. Link a Form to a Web Service

   8. Script InfoPath

   9. Program InfoPath in .NET

   10. Generate HTML Output

   11. Prevent Design Changes

1. About the Author

2. Colophon

Our look is the result of reader comments, our own experimentation, and feedback from distribution channels. Distinctive covers complement our distinctive approach to technical topics, breathing personality and life into potentially dry subjects. The Developer's Notebook series is modeled on the tradition of laboratory notebooks. Laboratory notebooks are an invaluable tool for researchers and their successors.

The purpose of a laboratory notebook is to facilitate the recording of data and conclusions as the work is being conducted, creating a faithful and immediate history. The notebook begins with a title page that includes the owner's name and the subject of research. The pages of the notebook should be numbered and prefaced with a table of contents. Entries must be clear, easy to read, and accurately dated; they should use simple, direct language to indicate the name of the experiment and the steps taken. Calculations are written out carefully and relevant thoughts and ideas recorded. Each experiment is introduced and summarized as it is added to the notebook. The goal is to produce comprehensive, clearly organized notes that can be used as a reference. Careful documentation creates a valuable record and provides a practical guide for future developers. Reg Aubry was the production editor and copyeditor for Excel 2003 Programming: A Developer's Notebook. Marlowe Shaeffer was the proofreader. Marlowe Shaeffer, Matt Hutchinson, and Claire Cloutier provided quality control. Lucie Haskins wrote the index.

Edie Freedman designed the cover of this book. Emma Colby and Clay Fernald produced the cover layout with QuarkXPress 4.1 using the Officina Sans and JuniorHandwriting fonts.

David Futato designed the interior layout, based on a series design by Edie Freedman and David Futato. This book was converted by Julie Hawks to FrameMaker 5.5.6 with a format conversion tool created by Erik Ray, Jason McIntosh, Neil Walls, and Mike Sierra that uses Perl and XML technologies. The text font is Adobe Boton; the heading font is ITC Officina Sans; the code font is LucasFont's TheSans Mono Condensed, and the handwriting font is a modified version of JRHand made by Tepid Monkey Fonts and modified by O'Reilly. The illustrations that appear in the book were produced by Robert Romano and Jessamyn Read using Macromedia FreeHand 9 and Adobe Photoshop 6. This colophon was written by Colleen Gorman.