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

This book is suitable for readers already familiar with the Excel user interface and introduces programming concepts via numerous multi-step, practical exercises. More advanced topics are introduced via custom projects. Covers recording and editing a macro and writing VBA code through working with XML documents and using ASP to display data on the Web. Microsoft Excel 2013 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. The chapters are 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.

Features:

• Explores in great detail the latest version of Excel and all of its features.
• Covers recording and editing a macro and writing VBA code through working with XL documents and using ASP to display data on the Web.
• Covers Office Web Apps.

Table of Contents

PART I—INTRODUCTION TO EXCEL 2013 VBA PROGRAMMING
Chapter 1 Automating Worksheet Tasks with Macros
Chapter 2 Exploring the Visual Basic Editor (VBE)
Chapter 3 Excel VBA Fundamentals
Chapter 4 Using Variables, Data Types, and Constants
Chapter 5 VBA Procedures: Subroutines and Functions

PART II—CONTROLLING PROGRAM EXECUTION
Chapter 6 Decision Making with VBA
Chapter 7 Repeating Actions in VBA

PART III—KEEPING TRACK OF MULTIPLE VALUES
Chapter 8 Working with Arrays
Chapter 9 Working with Collections and Class Modules

PART IV—ERROR HANDLING AND DEBUGGING
Chapter 10 VBE Tools for Testing and Debugging
Chapter 11 Conditional Compilation and Error Trapping

PART V—MANIPULATING FILES AND FOLDERS WITH VBA
Chapter 12 File and Folder Manipulation with VBA
Chapter 13 File and Folder Manipulation with Windows Script Host (WSH)
Chapter 14 Using Low-Level File Access

PART VI—CONTROLLING OTHER APPLICATIONS WITH VBA
Chapter 15 Using Excel VBA to Interact with Other Applications
Chapter 16 Using Excel with Microsoft Access

PART VII—ENHANCING THE USER EXPERIENCE
Chapter 17 Event-Driven Programming
Chapter 18 Using Dialog Boxes
Chapter 19 Creating Custom Forms
Chapter 20 Formatting Worksheets with VBA
Chapter 21 Context Menu Programming and Ribbon Customizations

PART VIII—PROGRAMMING EXCEL SPECIAL FEATURES
Chapter 22 Printing and Sending Email from Excel
Chapter 23 Programming PivotTables and PivotCharts
Chapter 24 Using and Programming Excel Tables
Chapter 25 Programming Special Features
Chapter 26 Programming the Visual Basic Editor (VBE)

PART IX—EXCEL AND WEB TECHNOLOGIES
Chapter 27 HTML Programming and Web Queries
Chapter 28 Excel and Active Server Pages
Chapter 29 Using XML in Excel 2013

PART X GOING BEYOND THE LIMITS OF VBA
Chapter 30 Calling Windows API Functions from VBA