Microsoft? Excel? 2010 Programming By Example: with VBA, XML, and ASP

Overview

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

See more details below
Paperback
$41.54
BN.com price
(Save 16%)$49.95 List Price

Pick Up In Store

Reserve and pick up in 60 minutes at your local store

Other sellers (Paperback)
  • All (12) from $37.70   
  • New (9) from $37.92   
  • Used (3) from $37.70   
Sending request ...

Overview

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.

Read More Show Less

Product Details

  • ISBN-13: 9781936420032
  • Publisher: Mercury Learning and Information
  • Publication date: 2/15/2011
  • Pages: 800
  • Sales rank: 1,465,719
  • Product dimensions: 7.00 (w) x 9.00 (h) x 1.50 (d)

Meet 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 over 20 computer books. She lives on Long Island, New York.

Read More Show Less

Table of Contents

1) 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

Read More Show Less

Customer Reviews

Be the first to write a review
( 0 )
Rating Distribution

5 Star

(0)

4 Star

(0)

3 Star

(0)

2 Star

(0)

1 Star

(0)

Your Rating:

Your Name: Create a Pen Name or

Barnes & Noble.com Review Rules

Our reader reviews allow you to share your comments on titles you liked, or didn't, with others. By submitting an online review, you are representing to Barnes & Noble.com that all information contained in your review is original and accurate in all respects, and that the submission of such content by you and the posting of such content by Barnes & Noble.com does not and will not violate the rights of any third party. Please follow the rules below to help ensure that your review can be posted.

Reviews by Our Customers Under the Age of 13

We highly value and respect everyone's opinion concerning the titles we offer. However, we cannot allow persons under the age of 13 to have accounts at BN.com or to post customer reviews. Please see our Terms of Use for more details.

What to exclude from your review:

Please do not write about reviews, commentary, or information posted on the product page. If you see any errors in the information on the product page, please send us an email.

Reviews should not contain any of the following:

  • - HTML tags, profanity, obscenities, vulgarities, or comments that defame anyone
  • - Time-sensitive information such as tour dates, signings, lectures, etc.
  • - Single-word reviews. Other people will read your review to discover why you liked or didn't like the title. Be descriptive.
  • - Comments focusing on the author or that may ruin the ending for others
  • - Phone numbers, addresses, URLs
  • - Pricing and availability information or alternative ordering information
  • - Advertisements or commercial solicitation

Reminder:

  • - By submitting a review, you grant to Barnes & Noble.com and its sublicensees the royalty-free, perpetual, irrevocable right and license to use the review in accordance with the Barnes & Noble.com Terms of Use.
  • - Barnes & Noble.com reserves the right not to post any review -- particularly those that do not follow the terms and conditions of these Rules. Barnes & Noble.com also reserves the right to remove any review at any time without notice.
  • - See Terms of Use for other conditions and disclaimers.
Search for Products You'd Like to Recommend

Recommend other products that relate to your review. Just search for them below and share!

Create a Pen Name

Your Pen Name is your unique identity on BN.com. It will appear on the reviews you write and other website activities. Your Pen Name cannot be edited, changed or deleted once submitted.

 
Your Pen Name can be any combination of alphanumeric characters (plus - and _), and must be at least two characters long.

Continue Anonymously

    If you find inappropriate content, please report it to Barnes & Noble
    Why is this product inappropriate?
    Comments (optional)