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
Microsoft® Office Excel 2003 Programming Inside Out
Take your Microsoft Office experience to the next level by programming custom business solutions with Excel …
book
Office 2003 XML
In Microsoft's Office 2003, users experience the merger of the power of the classic Office suite …
book
Professional Microsoft® SharePoint® Designer 2007
With Professional Microsoft Office SharePoint Designer 2007, you can master all aspects of using Share Point …
book
Excel® 2007 VBA Programmer's Reference
Get ready to take your Excel applications to the next level by harnessing the power of …