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.
Publisher resources
Table of contents
-
Excel 2003 Programming: A Developer’s Notebook
- The Developer’s Notebook Series
- Preface
- 1. Program the New Excel
-
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
- 3. Work with XML
- 4. Get Data from the Web
-
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
-
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
-
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
- How to do it
- Why use script?
-
Common script tasks
- Display a simple message box
- Save form data
- Send form data as an email attachment
- Get a value from a control
- Set a value of a control
- Get a form’s XML data
- Submit data
- Refresh secondary data sources
- Switch form views
- Display an HTML page
- Create a new form based on current template
- Create a new form based on a new template
- Open an existing form
- Quit InfoPath
- Debug and deploy
- What about...
- Program InfoPath in .NET
- Generate HTML Output
- Prevent Design Changes
- Index
- Colophon
Product information
- Title: Excel 2003 Programming: A Developer's Notebook
- Author(s):
- Release date: August 2004
- Publisher(s): O'Reilly Media, Inc.
- ISBN: 9780596007676
You might also like
book
C# for Financial Markets
A practice-oriented guide to using C# to design and program pricing and trading models In this …
book
Excel 2016 Power Programming with VBA
Maximize your Excel experience with VBA Excel 2016 Power Programming with VBA is fully updated to …
book
Excel VBA Programming For Dummies
Take your data analysis and Excel programming skills to new heights In order to take Excel …
book
Excel 2013 Power Programming with VBA
Maximize your Excel 2013 experience using VBA application development The new Excel 2013 boasts updated features, …