Skip to Main Content
Excel 2003 Programming: A Developer's Notebook
book

Excel 2003 Programming: A Developer's Notebook

by Jeff Webb
August 2004
Intermediate to advanced content levelIntermediate to advanced
312 pages
8h 30m
English
O'Reilly Media, Inc.
Content preview from Excel 2003 Programming: A Developer's Notebook

Try It

That’s the grand vision, but even if you don’t intend to install SharePoint or build a web-based interface to your business processes, you can still make use of the new Excel features. Table 1-1 is a guide to the new Excel features, where they are located in this book, and how to use them.

Note

Is Excel 2003 a big deal? On the surface, not much has changed— there are a handful of new objects and the user interface of Excel is largely the same. Underneath that 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.

Table 1-1. Guide to Excel 2003 features

FeatureLook hereUse to

Workspaces and lists

Chapter 2

Share workbooks and ranges of cells. Sort and filter ranges of cells. Control user access to shared items.

XML

Chapter 3

Transform spreadsheets into HTML and other formats. Transform XML data files into workbooks. Map XML data to ranges of cells.

Web services

Chapter 4

Get dynamic results from the Web. Control remote components, such as SharePoint lists, through VBA code.

.NET programmability

Chapter 5

Build .NET components to use from Excel. Work with Excel from VB.NET. Create Excel .NET applications.

Security

Chapter 6

Password-protect workbooks and ranges. Control user access to ranges. Restrict permissions on workbooks. Digitally sign workbooks and macros. Distribute Excel security settings.

InfoPath

Chapter 7

Create XML data ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Microsoft® Office Excel 2003 Programming Inside Out

Microsoft® Office Excel 2003 Programming Inside Out

Curtis Frye, Wayne S. Freeze, Felicia K. Buckingham
Excel® 2007 VBA Programmer's Reference

Excel® 2007 VBA Programmer's Reference

John Green, Stephen Bullen, Rob Bovey, Michael Alexander
Office 2003 XML

Office 2003 XML

Simon St. Laurent, Mary McRae, Evan Lenz

Publisher Resources

ISBN: 0596007671Supplemental ContentCatalog PageErrata