| |
| |
| The Developer's Notebook Series | |
| |
| |
| Preface | |
| |
| |
| |
| 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? | |
| |
| |
| |
| 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 | |
| |
| |
| |
| 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 | |
| |
| |
| |
| 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 | |
| |
| |
| |
| 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 | |
| |
| |
| |
| 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 | |
| |
| |
| |
| 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 | |