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.

Product Description: Microsoft Excel 2010 Programming by Example with VBA, XML and ASP is a practical how-to book on Exce....

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

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. Includes sealed CD. Bookseller Inventory # mon0001537145

More Information About This Seller | Ask Bookseller a Question

Buy Used
US$ 25.61
Convert Currency

Add to Basket

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

2.

Korol, Julitta
Published by Mercury Learning & Information (2011)
ISBN 10: 1936420031 ISBN 13: 9781936420032
Used Paperback Quantity Available: 1
Seller
HPB-Dallas
(Dallas, TX, U.S.A.)
Rating
[?]

Book Description Mercury Learning & Information, 2011. Paperback. Book Condition: Good. Item may show signs of shelf wear. Pages may include limited notes and highlighting. Includes supplemental or companion materials if applicable. Access codes may or may not work. Connecting readers since 1972. Customer service is our top priority. Bookseller Inventory # mon0001183645

More Information About This Seller | Ask Bookseller a Question

Buy Used
US$ 26.03
Convert Currency

Add to Basket

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

3.

Korol, Julitta
Published by Mercury Learning & Information
ISBN 10: 1936420031 ISBN 13: 9781936420032
Used PAPERBACK Quantity Available: 1
Seller
Recycle-A-Textbook
(Lexington, KY, U.S.A.)
Rating
[?]

Book Description Mercury Learning & Information. PAPERBACK. Book Condition: Good. 1936420031 Good condition with normal wear. Supplemental materials such as CDs or access codes may NOT be included regardless of title. May have bookstore stickers on cover. Expedited shipping available (2-4 day delivery)! Contact us with any questions!. Bookseller Inventory # Z1936420031Z3

More Information About This Seller | Ask Bookseller a Question

Buy Used
US$ 25.87
Convert Currency

Add to Basket

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

4.

Korol, Julitta
ISBN 10: 1936420031 ISBN 13: 9781936420032
New Quantity Available: > 20
Seller
Paperbackshop-US
(Wood Dale, IL, U.S.A.)
Rating
[?]

Book Description 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.53
Convert Currency

Add to Basket

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

5.

Julitta Korol
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$ 52.24
Convert Currency

Add to Basket

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

6.

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$ 54.14
Convert Currency

Add to Basket

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

7.

Julitta Korol
Published by Mercury Learning & Information
ISBN 10: 1936420031 ISBN 13: 9781936420032
New Quantity Available: 1
Seller
THE SAINT BOOKSTORE
(Southport, United Kingdom)
Rating
[?]

Book Description Mercury Learning & Information. Mixed media product. Book Condition: new. BRAND NEW, Microsoft Excel 2010 Programming by Example with VBA, XML, and ASP, Julitta Korol, "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 # B9781936420032

More Information About This Seller | Ask Bookseller a Question

Buy New
US$ 52.16
Convert Currency

Add to Basket

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

8.

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$ 50.99
Convert Currency

Add to Basket

Shipping: US$ 3.99
Within 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: 10
Seller
Book Depository hard to find
(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 . This book usually ship within 10-15 business days and we will endeavor to dispatch orders quicker than this where possible. 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 # BTE9781936420032

More Information About This Seller | Ask Bookseller a Question

Buy New
US$ 55.06
Convert Currency

Add to Basket

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

10.

ISBN 10: 1936420031 ISBN 13: 9781936420032
New Quantity Available: 2
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$ 58.09
Convert Currency

Add to Basket

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

There are 10 more copies of this book

View all search results for this book