---

Excel 2003 Programming: A Developers Notebook (Developers Notebook)

ISBN: 0596007671
EAN: 2147483647

Year: 2004
Pages: 133

Authors: Jeff Webb

BUY ON AMAZON

• Excel 2003 Programming: A Developer s Notebook
• Table of Contents
• Copyright
• The Developer s Notebook Series
• Notebooks Are...
• Notebooks Aren t...
• Organization
• Preface
• Don t Force It
• Get the Samples
• Font Conventions
• How to Contact Us
• Acknowledgments
• Chapter 1. Program the New Excel
• Section 1.1.Dude, Where s My Data?
• Section 1.2.How the Pieces Fit
• Section 1.3.Try It
• Section 1.4. Kick-Start Lists and XML
• Section 1.5.Kick-Start SharePoint
• Section 1.6.Kick-Start Web Services
• Section 1.7.Kick-Start Security and .NET
• Section 1.8.Kick-Start InfoPath
• Section 1.9.What Next?
• Chapter 2. Share Workspaces and Lists
• Section 2.1.Get SharePoint Services
• Section 2.2.Create a Shared Workspace
• Section 2.3.Share a Workbook
• Section 2.4.Open a Shared Workbook
• Section 2.5.Display a SharePoint Site
• Section 2.6. Remove Sharing
• Section 2.7.Add Users and Permissions
• Section 2.8.Allow Anonymous Users
• Section 2.9.Create a List
• Section 2.10.Share a List
• Section 2.11.Update a Shared List
• Section 2.12.Insert a Shared List
• Section 2.13.Delete or Unlink a Shared List
• Section 2.14.Use the Lists Web Service
• Chapter 3. Work with XML
• Section 3.1. Speak XML
• Section 3.2. XML Side-story
• Section 3.3. Save Workbooks as XML
• Section 3.4. Transform XML Spreadsheets
• Section 3.5. Transform XML into a Spreadsheet
• Section 3.6. Use XML Maps
• Section 3.7. Exporting Through XML Maps
• Section 3.8. Use Templates with XML
• Section 3.9. Respond to XML Events
• Section 3.10. Program with XML Maps
• Section 3.11. Get an XML Map from a List or Range
• Chapter 4. Get Data from the Web
• Section 4.1.Perform Web Queries
• Section 4.2. Modify a Web Query
• Section 4.3. Perform Periodic Updates
• Section 4.4.Manage Web Queries
• Section 4.5.Use Web Services
• Section 4.6.Use the Web Services Toolkit
• Section 4.7. Use Web Services Through XML
• Section 4.8. Call a Web Service Asynchronously
• Section 4.9. Reformat XML Results for Excel
• Chapter 5. Program Excel with .NET
• Section 5.1.Work with .NET
• Section 5.2.Create .NET Components
• Section 5.3.Use .NET Components
• Section 5.4.Respond to Errors and Events from .NET
• Section 5.5.Debug .NET Components
• Section 5.6.Distribute .NET Components
• Section 5.7.Use Excel as a Component in .NET
• Section 5.8.Work with Excel Objects in .NET
• Section 5.9.Respond to Excel Events in .NET
• Section 5.10.Respond to Excel Errors in .NET
• Section 5.11.Distribute .NET Applications That Use Excel
• Section 5.12.Create Excel .NET Applications
• Section 5.13.Set .NET Security Policies
• Section 5.14.Respond to Events in .NET Applications
• Section 5.15.Debug Excel .NET Applications
• Section 5.16.Display Windows Forms
• Section 5.17.Distribute Excel .NET Applications
• Section 5.18.Distribute Excel .NET Documents
• Section 5.19.Migrate to .NET
• Chapter 6. Explore Security in Depth
• Section 6.1.Dress in Layers
• Section 6.2. Use Windows Security
• Section 6.3.Password Protect and Encrypt Workbooks
• Section 6.4.Program with Passwords and Encryption
• Section 6.5.Protect Items in a Workbook
• Section 6.6.Program with Protection
• Section 6.7. Use Identity-Based Security (a.k.a. IRM)
• Section 6.8.Program with Permissions
• Section 6.9.Add Digital Signatures
• Section 6.10.Set Macro Security
• Section 6.11.Distribute Security Settings
• Section 6.12.Common Questions
• Chapter 7. Build InfoPath Forms
• Section 7.1.Are InfoPath Forms Better?
• Section 7.2.InfoPath and Excel
• Section 7.3.Share Data
• Section 7.4.Link a Form to a Database
• Section 7.5.Populate a Control from a Data Source
• Section 7.6.Validate Data
• Section 7.7.Link a Form to a Web Service
• Section 7.8.Script InfoPath
• Section 7.9.Program InfoPath in .NET
• Section 7.10.Generate HTML Output
• Section 7.11.Prevent Design Changes
• About the Author
• Colophon
• Index
• A
• B
• C
• D
• E
• F
• G
• H
• I
• J
• K
• L
• M
• N
• O
• P
• Q
• R
• S
• T
• U
• V
• W
• X