Publisher: O'Reilly Media Released: August 2004 Pages: 312
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. |
-
Chapter 1 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? -
Chapter 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 -
Chapter 3 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 -
Chapter 4 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 -
Chapter 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 -
Chapter 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 -
Chapter 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 -
Program InfoPath in .NET -
Generate HTML Output -
Prevent Design Changes -
Colophon |
- Title:
- Excel 2003 Programming: A Developer's Notebook
- By:
- Jeff Webb
- Publisher:
- O'Reilly Media
- Formats:
-
- Print
- Safari Books Online
- Print:
- August 2004
- Pages:
- 312
- Print ISBN:
- 978-0-596-00767-6
- | ISBN 10:
- 0-596-00767-1
|
-
Jeff Webb 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. View Jeff Webb's full profile page. |
Colophon Our look is the result of reader comments, our own experimentation, and feedback from distribution channels. Distinctive covers complement our distinctive approach to technical topics, breathing personality and life into potentially dry subjects. The Developer's Notebook series is modeled on the tradition of laboratory notebooks. Laboratory notebooks are an invaluable tool for researchers and their successors. The purpose of a laboratory notebook is to facilitate the recording of data and conclusions as the work is being conducted, creating a faithful and immediate history. The notebook begins with a title page that includes the owner's name and the subject of research. The pages of the notebook should be numbered and prefaced with a table of contents. Entries must be clear, easy to read, and accurately dated; they should use simple, direct language to indicate the name of the experiment and the steps taken. Calculations are written out carefully and relevant thoughts and ideas recorded. Each experiment is introduced and summarized as it is added to the notebook. The goal is to produce comprehensive, clearly organized notes that can be used as a reference. Careful documentation creates a valuable record and provides a practical guide for future developers. Reg Aubry was the production editor and copyeditor for Excel 2003 Programming: A Developer's Notebook. Marlowe Shaeffer was the proofreader. Marlowe Shaeffer, Matt Hutchinson, and Claire Cloutier provided quality control. Lucie Haskins wrote the index. Edie Freedman designed the cover of this book. Emma Colby and Clay Fernald produced the cover layout with QuarkXPress 4.1 using the Officina Sans and JuniorHandwriting fonts. David Futato designed the interior layout, based on a series design by Edie Freedman and David Futato. This book was converted by Julie Hawks to FrameMaker 5.5.6 with a format conversion tool created by Erik Ray, Jason McIntosh, Neil Walls, and Mike Sierra that uses Perl and XML technologies. The text font is Adobe Boton; the heading font is ITC Officina Sans; the code font is LucasFont's TheSans Mono Condensed, and the handwriting font is a modified version of JRHand made by Tepid Monkey Fonts and modified by O'Reilly. The illustrations that appear in the book were produced by Robert Romano and Jessamyn Read using Macromedia FreeHand 9 and Adobe Photoshop 6. This colophon was written by Colleen Gorman. |
|
Description
|
Table of Contents
|
Product Details
|
About the Author
|
Colophon
|
 |
|
 |
|
|
|
Recommended for You
|
Recently Viewed
|
 |
|
By Richard Monson-Haefel, Bill Burke, Sacha Labourey
June 2004
By Bob Boufford
June 1998
By Jim Elferdink
September 2005
Ebook: $19.99
Print & Ebook: $27.45
Print: $24.95
|
Customer Reviews
|
|
|