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

Julitta Korol

Published by Mercury Learning & Information
ISBN 10: 1936420031 / ISBN 13: 9781936420032
Used / Paperback / Quantity Available: 0
Available From More Booksellers
View all  copies of this book

About the Book

We're sorry; this specific copy is no longer available. AbeBooks has millions of books. We've listed similar copies below.

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 #

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.

Bibliographic Details

Title: Microsoft Excel 2010 Programming by Example ...
Publisher: Mercury Learning & Information

Binding: Paperback
Book Condition: New

Top Search Results from the AbeBooks Marketplace

1.

Korol, Julitta
ISBN 10: 1936420031 ISBN 13: 9781936420032
New Quantity Available: 5
Seller
GreatBookPrices
(Columbia, MD, U.S.A.)
Rating
[?]

Book Description Book Condition: New. Bookseller Inventory # 11861417-n

More Information About This Seller | Ask Bookseller a Question

Buy New
US$ 28.14
Convert Currency

Add to Basket

Shipping: US$ 2.64
Within U.S.A.
Destination, Rates & Speeds

2.

Julitta Korol
Published by Mercury Learning & Information (2011)
ISBN 10: 1936420031 ISBN 13: 9781936420032
Used Paperback Quantity Available: 1
Seller
Books From California
(Simi Valley, CA, U.S.A.)
Rating
[?]

Book Description Mercury Learning & Information, 2011. Paperback. Book Condition: Very Good. Bookseller Inventory # mon0001512519

More Information About This Seller | Ask Bookseller a Question

Buy Used
US$ 27.02
Convert Currency

Add to Basket

Shipping: US$ 3.99
Within U.S.A.
Destination, Rates & Speeds

3.

Korol, Julitta
Published by Stylus Pub Llc (2011)
ISBN 10: 1936420031 ISBN 13: 9781936420032
New Quantity Available: > 20
Seller
Paperbackshop-US
(Commerce, GA, U.S.A.)
Rating
[?]

Book Description Stylus Pub Llc, 2011. PAP. Book Condition: New. New Book. Shipped from US within 10 to 14 business days. Established seller since 2000. Bookseller Inventory # T8-9781936420032

More Information About This Seller | Ask Bookseller a Question

Buy New
US$ 27.37
Convert Currency

Add to Basket

Shipping: US$ 3.99
Within U.S.A.
Destination, Rates & Speeds

4.

Korol, Julitta
Published by Mercury Learning & Information (2011)
ISBN 10: 1936420031 ISBN 13: 9781936420032
New Paperback Quantity Available: 1
Seller
Irish Booksellers
(Rumford, ME, U.S.A.)
Rating
[?]

Book Description Mercury Learning & Information, 2011. Paperback. Book Condition: New. book. Bookseller Inventory # 1936420031

More Information About This Seller | Ask Bookseller a Question

Buy New
US$ 51.95
Convert Currency

Add to Basket

Shipping: FREE
Within U.S.A.
Destination, Rates & Speeds

5.

Julitta Korol
Published by Mercury Learning & Information (2012)
ISBN 10: 1936420031 ISBN 13: 9781936420032
New Paperback Quantity Available: 1
Seller
Ergodebooks
(RICHMOND, TX, U.S.A.)
Rating
[?]

Book Description Mercury Learning & Information, 2012. Paperback. Book Condition: New. Paperback with CD-ROM. Bookseller Inventory # DADAX1936420031

More Information About This Seller | Ask Bookseller a Question

Buy New
US$ 49.53
Convert Currency

Add to Basket

Shipping: US$ 3.99
Within U.S.A.
Destination, Rates & Speeds

6.

ISBN 10: 1936420031 ISBN 13: 9781936420032
New Quantity Available: > 20
Seller
BWB
(Valley Stream, NY, U.S.A.)
Rating
[?]

Book Description Book Condition: New. Depending on your location, this item may ship from the US or UK. Bookseller Inventory # 97819364200320000000

More Information About This Seller | Ask Bookseller a Question

Buy New
US$ 56.63
Convert Currency

Add to Basket

Shipping: FREE
Within U.S.A.
Destination, Rates & Speeds

7.

Julitta Korol
Published by Mercury Learning Information, United States (2011)
ISBN 10: 1936420031 ISBN 13: 9781936420032
New Quantity Available: 1
Seller
The Book Depository US
(London, United Kingdom)
Rating
[?]

Book Description Mercury Learning Information, United States, 2011. Mixed media product. Book Condition: New. New.. 226 x 178 mm. Language: English . Brand New Book. 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. Bookseller Inventory # AAJ9781936420032

More Information About This Seller | Ask Bookseller a Question

Buy New
US$ 65.44
Convert Currency

Add to Basket

Shipping: FREE
From United Kingdom to U.S.A.
Destination, Rates & Speeds

8.

Julitta Korol
ISBN 10: 1936420031 ISBN 13: 9781936420032
New Paperback Quantity Available: 1
Seller
AussieBookSeller
(SILVERWATER, NSW, Australia)
Rating
[?]

Book Description 2011. Paperback. Book Condition: New. 178mm x 229mm x 35mm. Paperback. 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 in.Shipping may be from our Sydney, NSW warehouse or from our UK or US warehouse, depending on stock availability. 800 pages. 1.895. Bookseller Inventory # 9781936420032

More Information About This Seller | Ask Bookseller a Question

Buy New
US$ 65.70
Convert Currency

Add to Basket

Shipping: US$ 28.00
From Australia to U.S.A.
Destination, Rates & Speeds

9.

Julitta Korol
Published by Mercury Learning Information, United States (2011)
ISBN 10: 1936420031 ISBN 13: 9781936420032
New Quantity Available: 1
Seller
The Book Depository
(London, United Kingdom)
Rating
[?]

Book Description Mercury Learning Information, United States, 2011. Mixed media product. Book Condition: New. New.. 226 x 178 mm. Language: English . Brand New Book. 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. Bookseller Inventory # AAJ9781936420032

More Information About This Seller | Ask Bookseller a Question

Buy New
US$ 69.72
Convert Currency

Add to Basket

Shipping: FREE
From United Kingdom to U.S.A.
Destination, Rates & Speeds

10.

Julitta Korol
Published by Mercury Learning and Information (2011)
ISBN 10: 1936420031 ISBN 13: 9781936420032
New Quantity Available: 1
Seller
Books2Anywhere
(Fairford, GLOS, United Kingdom)
Rating
[?]

Book Description Mercury Learning and Information, 2011. UNK. Book Condition: New. New Book. Shipped from UK in 4 to 14 days. Established seller since 2000. Bookseller Inventory # CD-9781936420032

More Information About This Seller | Ask Bookseller a Question

Buy New
US$ 66.97
Convert Currency

Add to Basket

Shipping: US$ 11.16
From United Kingdom to U.S.A.
Destination, Rates & Speeds

There are 6 more copies of this book

View all search results for this book