Stock Image

Microsoft Excel 2010 Programming by Example with VBA, XML, and ASP

Julitta Korol

Published by Mercury Learning & Information
ISBN 10: 1936420031 / ISBN 13: 9781936420032
New / Paperback / Quantity Available: 1
From BuySomeBooks (Las Vegas, NV, U.S.A.)
Available From More Booksellers
View all  copies of this book
Add to basket
List Price: US$
Price: US$ 60.96
Convert Currency
Shipping: US$ 3.95
Within U.S.A.
Destination, Rates & Speeds

30 Day Returns Policy

Save for Later

About the Book

Bibliographic Details


Title: Microsoft Excel 2010 Programming by Example ...

Publisher: Mercury Learning & Information

Binding: Paperback

Book Condition: New

Book Type: Paperback

Description:

Paperback. 1080 pages. Dimensions: 8.9in. x 7.0in. x 1.6in.Microsoft Excel 2010 Programming by Example with VBA, XML and ASP is a practical how-to book on Excel programming, suitable for readers already familiar with the Excel user interface. The book introduces programming concepts via numerous multi-step, illustrated, hands-on exercises. More advanced topics are introduced via custom projects. From recording and editing a macro and writing VBA code to working with XML documents and using classic ASP to access and display data on the Web, this book takes you on a programming journey that will change the way you work with Excel. Completely updated for Excel 2010, this book provides information on performing automatic operations on files, folders, and other Microsoft Office applications. It also covers proper use of event procedures, testing and debugging, and programming advanced Excel features such as PivotTables, PivotCharts, and SmartTags. Thirty chapters loaded with illustrated hands-on projects and exercises that tell you exactly where to enter code, how to debug it, and then run it. Each exerciseproject step is clearly explained as it is performed. Table of Contents1. Automating Worksheet Tasks with Macros. 2. Exploring the Visual Basic Editor (VBE). 3. Excel VBA Fundamentals. 4. Using Variables, Data Types, and Constants. 5. VBA Procedures: Subroutines and Functions. 6. Decision Making with VBA. 7. Repeating Actions in VBA. 8. Working with Arrays. 9. Working with Collections and Class Modules. 10. VBE Tools for Testing and Debugging. 11. Conditional Compilation and Error Trapping. 12. File and Folder Manipulation with VBA. 13. File and Folder Manipulation with Windows Script Host (WSH). 14. Using Low-Level File Access. 15. Using Excel VBA to Interact with Other Applications. 16. Using Excel with Microsoft Access. 17. Event-Driven Programming. 18. Using Dialog Boxes. 19. Creating Custom Forms. 20. Formatting Worksheets with VBA. 21. Context Menu Programming and Ribbon Customizations. 22. Printing and Sending E-mail from Excel. 23. Programming PivotTables and PivotCharts. 24. Using and Programming Excel Tables. 25. Programming Special Features. 26. Programming the Visual Basic Editor (VBE). 27. HTML Programming and Web Queries. 28. Excel and Active Server Pages. 29. Using XML in Excel 2010. 30. Calling Windows API Functions from VBA. Index. This item ships from multiple locations. Your book may arrive from Roseburg,OR, La Vergne,TN. Bookseller Inventory # 9781936420032

About this title:

Book ratings provided by GoodReads:
4 avg rating
(3 ratings)

Synopsis: "Microsoft Excel 2010 Programming by Example with VBA, XML and ASP" is a practical how-to book on Excel programming, suitable for readers already familiar with the Excel user interface. The book introduces programming concepts via numerous multi-step, illustrated, hands-on exercises. More advanced topics are introduced via custom projects. From recording and editing a macro and writing VBA code to working with XML documents and using classic ASP to access and display data on the Web, this book takes you on a programming journey that will change the way you work with Excel. Completely updated for Excel 2010, this book provides information on performing automatic operations on files, folders, and other Microsoft Office applications. It also covers proper use of event procedures, testing and debugging, and programming advanced Excel features such as PivotTables, PivotCharts, and SmartTags. Thirty chapters loaded with illustrated hands-on projects and exercises that tell you exactly where to enter code, how to debug it, and then run it. Each exercise/project step is clearly explained as it is performed. This title includes thirty chapters loaded with illustrated hands-on projects and exercises that demonstrate programming concepts. Each exercise/project tells you exactly where to enter code and how to debug it and then run it. It includes a comprehensive CD-ROM with tips, shortcuts, and tutorials. It is updated for Excel 2010 and based on the bestselling editions from previous versions. It uses the Excel built-in Visual Basic development environment and its numerous tools. It manipulates and formats worksheet data programmatically. It provides rich user experience with dialog boxes, custom forms, ribbon design, and the proper use of event procedures. Learn to perform automatic operations on files, folders and MS Office applications. Test your procedures with debugging tools, and write custom error handling code. Program advanced Excel features such as PivotTables, PivotCharts, and SmartTags. Harness the power of XML and ASP.

About the Author: Julitta Korol is a software consultant who delivers custom-tailored hands-on training and develops advanced database and spreadsheet applications. She has written a dozen computer books including Microsoft Access 2010 with VBA, XML and ASP (Mercury Learning). She lives on Long Island, New York.

"About this title" may belong to another edition of this title.

Bookseller & Payment Information

Payment Methods

This bookseller accepts the following methods of payment:

  • American Express
  • MasterCard
  • Visa

[Search this Seller's Books]

[List this Seller's Books]

[Ask Bookseller a Question]

Bookseller: BuySomeBooks
Address: Las Vegas, NV, U.S.A.

AbeBooks Bookseller Since: May 21, 2012
Bookseller Rating: 5-star rating

Terms of Sale:

We guarantee the condition of every book as it's described on the Abebooks web
sites. If you're dissatisfied with your purchase (Incorrect Book/Not as
Described/Damaged) or if the order hasn't arrived, you're eligible for a refund
within 30 days of the estimated delivery date. If you've changed your mind about a book that you've ordered, please use the Ask bookseller a question link to contact us and we'll respond within 2 business days.

BuySomeBooks is operated by Drive-On-In, Inc., a Nevada co...

[More Information]

Shipping Terms:

Orders usually ship within 1-2 business days. Books are shipped from multiple locations so your order may arrive from Las Vegas,NV, Roseburg,OR, La Vergne,TN, Momence,IL, or Commerce,GA.


Store Description: BuySomeBooks is great place to get your books online. With over eight million titles available we're sure to have what you're looking for. Despite having a large selection of new books available for immediate shipment and excellent customer service, people still tell us they prefer us because of our prices.