Skip to content

Excel 2003 Programming

Spend $50 to get a free DVD!

ISBN-10: 0596007671

ISBN-13: 9780596007676

Edition: 2004

Authors: Jeff Webb

List price: $29.95
Blue ribbon 30 day, 100% satisfaction guarantee!
what's this?
Rush Rewards U
Members Receive:
Carrot Coin icon
XP icon
You have reached 400 XP and carrot coins. That is the daily max!

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…    
Customers also bought

Book details

List price: $29.95
Copyright year: 2004
Publisher: O'Reilly Media, Incorporated
Publication date: 8/30/2004
Binding: Paperback
Pages: 314
Size: 7.00" wide x 9.25" long x 1.00" tall
Weight: 1.100
Language: English

Eric is the author of the critically acclaimed online tutorial Introduction to HTML, as well as some other semi-popular Web pages. He is a member of the CSS&FP Working Group and the author of Cascading Style Sheets: The Definitive Guide.Jeff Webb is a SharePoint consultant and trainer who has written about computers and technology for 20 years. Among his published O'Reilly titles are Essential SharePoint, SharePoint Office Pocket Guide, Programming Excel with VBA and .NET, and Excel 2003 Programming: A Developer's Notebook. Jeff was an original member of Microsoft's Visual Basic team.

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