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

Chapter 1. Program the New Excel

You’ve probably seen Microsoft’s TV spots where the office workers are cheering, sliding down the hall on their knees, and otherwise celebrating their fantastic achievements. The message I get from that is not what Microsoft Office can do; it’s what the team can do together.

You may or may not like those ads, but their point is valid: Office 2003 isn’t really about features, it’s about cooperation. This book is an Excel programmer’s guide to that way of thinking.

Dude, Where’s My Data?

Not long ago we were hearing how software helped us work with data; now it’s how software helps us work with others. But where did the data go? More and more it’s hiding behind a web page.

Folks know how to use web pages: they click a link and go to a new page, they click a button to add something to their shopping cart, type in their payment info, check out, and then get confirmation in email. Those actions now seem so natural they need little explanation.

You can do the same thing with your office processes: click on a link, fill out an expense report, and click a button to submit it for approval. These web-based processes replace the document-based approach. Instead of .doc and .xls files flying around you’ve got a single data format shared between the browser, email, database, and Office applications: XML.

Think of all the information where you work as a giant stream of XML data. You navigate the stream using your browser and you use Office applications to ...

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