Excel 2003 Programming
Book 1
Book 2
Book 3
Book 1
Book 2
Book 3
Book 1
Book 2
Book 3
Book 1
Book 2
Book 3
Home > Computing and Information Technology > Business applications > Spreadsheet software > Excel 2003 Programming: (Developer's Notebook)
Excel 2003 Programming: (Developer's Notebook)

Excel 2003 Programming: (Developer's Notebook)


     0     
5
4
3
2
1



Out of Stock


Notify me when this book is in stock
X
About the Book

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. "

Table of Contents:
Preface 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 Index

About the Author :
Jeff Webb has written about computers and technology for 20 years. His books include Using Excel Visual Basic for Applications; Visual Basic Developer's Workshop; and Developing Web Applications with Visual Basic .NET. He has also written programming guides, articles, and sample applications for Microsoft and Digital Equipment Corporation.


Best Sellers


Product Details
  • ISBN-13: 9780596007676
  • Publisher: O'Reilly Media
  • Publisher Imprint: O'Reilly Media
  • Height: 236 mm
  • No of Pages: 314
  • Returnable: Y
  • Series Title: Developer's Notebook
  • Width: 179 mm
  • ISBN-10: 0596007671
  • Publisher Date: 28 Sep 2004
  • Binding: Paperback
  • Language: English
  • Returnable: Y
  • Returnable: Y
  • Spine Width: 20 mm


Similar Products

Add Photo
Add Photo

Customer Reviews

REVIEWS      0     
Click Here To Be The First to Review this Product
Excel 2003 Programming: (Developer's Notebook)
O'Reilly Media -
Excel 2003 Programming: (Developer's Notebook)
Writing guidlines
We want to publish your review, so please:
  • keep your review on the product. Review's that defame author's character will be rejected.
  • Keep your review focused on the product.
  • Avoid writing about customer service. contact us instead if you have issue requiring immediate attention.
  • Refrain from mentioning competitors or the specific price you paid for the product.
  • Do not include any personally identifiable information, such as full names.

Excel 2003 Programming: (Developer's Notebook)

Required fields are marked with *

Review Title*
Review
    Add Photo Add up to 6 photos
    Would you recommend this product to a friend?
    Tag this Book Read more
    Does your review contain spoilers?
    What type of reader best describes you?
    I agree to the terms & conditions
    You may receive emails regarding this submission. Any emails will include the ability to opt-out of future communications.

    CUSTOMER RATINGS AND REVIEWS AND QUESTIONS AND ANSWERS TERMS OF USE

    These Terms of Use govern your conduct associated with the Customer Ratings and Reviews and/or Questions and Answers service offered by Bookswagon (the "CRR Service").


    By submitting any content to Bookswagon, you guarantee that:
    • You are the sole author and owner of the intellectual property rights in the content;
    • All "moral rights" that you may have in such content have been voluntarily waived by you;
    • All content that you post is accurate;
    • You are at least 13 years old;
    • Use of the content you supply does not violate these Terms of Use and will not cause injury to any person or entity.
    You further agree that you may not submit any content:
    • That is known by you to be false, inaccurate or misleading;
    • That infringes any third party's copyright, patent, trademark, trade secret or other proprietary rights or rights of publicity or privacy;
    • That violates any law, statute, ordinance or regulation (including, but not limited to, those governing, consumer protection, unfair competition, anti-discrimination or false advertising);
    • That is, or may reasonably be considered to be, defamatory, libelous, hateful, racially or religiously biased or offensive, unlawfully threatening or unlawfully harassing to any individual, partnership or corporation;
    • For which you were compensated or granted any consideration by any unapproved third party;
    • That includes any information that references other websites, addresses, email addresses, contact information or phone numbers;
    • That contains any computer viruses, worms or other potentially damaging computer programs or files.
    You agree to indemnify and hold Bookswagon (and its officers, directors, agents, subsidiaries, joint ventures, employees and third-party service providers, including but not limited to Bazaarvoice, Inc.), harmless from all claims, demands, and damages (actual and consequential) of every kind and nature, known and unknown including reasonable attorneys' fees, arising out of a breach of your representations and warranties set forth above, or your violation of any law or the rights of a third party.


    For any content that you submit, you grant Bookswagon a perpetual, irrevocable, royalty-free, transferable right and license to use, copy, modify, delete in its entirety, adapt, publish, translate, create derivative works from and/or sell, transfer, and/or distribute such content and/or incorporate such content into any form, medium or technology throughout the world without compensation to you. Additionally,  Bookswagon may transfer or share any personal information that you submit with its third-party service providers, including but not limited to Bazaarvoice, Inc. in accordance with  Privacy Policy


    All content that you submit may be used at Bookswagon's sole discretion. Bookswagon reserves the right to change, condense, withhold publication, remove or delete any content on Bookswagon's website that Bookswagon deems, in its sole discretion, to violate the content guidelines or any other provision of these Terms of Use.  Bookswagon does not guarantee that you will have any recourse through Bookswagon to edit or delete any content you have submitted. Ratings and written comments are generally posted within two to four business days. However, Bookswagon reserves the right to remove or to refuse to post any submission to the extent authorized by law. You acknowledge that you, not Bookswagon, are responsible for the contents of your submission. None of the content that you submit shall be subject to any obligation of confidence on the part of Bookswagon, its agents, subsidiaries, affiliates, partners or third party service providers (including but not limited to Bazaarvoice, Inc.)and their respective directors, officers and employees.

    Accept

    Fresh on the Shelf


    Inspired by your browsing history


    Your review has been submitted!

    You've already reviewed this product!