Microsoft Excel 2016 Programming by Example : With VBA, XML, and ASP
- 14h 17m
- Julitta Korol
- Mercury Learning
- 2017
Microsoft Excel 2016 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 2016, this book provides information on performing automatic operations on files, folders, and other Microsoft Office and Web applications. 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.
FEATURES
- Updated for MS Excel 2016 and previous versions
- Includes 30 chapters and more than 275 applied examples and 10 projects
- Covers HTML and Office Web Apps
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 over 20 computer books including Microsoft Access 2013 Programming with VBA, XML and ASP (Mercury Learning).
In this Book
-
Introduction
-
Excel Macros—A Quick Start in Excel VBA Programming
-
Excel Programming Environment—A Quick Overview of its Tools and Features (VBE)
-
Excel VBA Fundamentals—A Quick Reference to Writing VBA Code
-
Excel VBA Procedures—A Quick Guide to Writing Function Procedures
-
Adding Decisions to Excel VBA Programs—A Quick Introduction to Conditional Statements
-
Adding Repeating Actions to Excel VBA Programs—A Quick Introduction to Looping Statements
-
Storing Multiple Values in Excel VBA Programs—A Quick Introduction to Working with Arrays
-
Keeping Track of Multiple Values in Excel VBA Programs—A Quick Introduction to Creating and Using Collections
-
Excel Tools for Testing and Debugging—A Quick Introduction to Testing VBA Programs
-
File and Folder Manipulation with VBA
-
File and Folder Manipulation with Windows Script Host (WSH)
-
Using Low-Level File Access
-
Using Excel VBA to Interact with other Applications
-
Using Excel with Microsoft Access
-
Event-Driven Programming
-
Using Dialog Boxes
-
Creating Custom Forms
-
Formatting Worksheets with VBA
-
Context Menu Programming and Ribbon Customizations
-
Printing and Sending Email from Excel
-
Using and Programming Excel Tables
-
Programming Pivottables and Pivotcharts
-
Getting and Transforming Data in Excel 2016
-
Programming the Visual Basic Editor (VBE)
-
Calling Windows API Functions from VBA
-
HTML Programming and Web Queries
-
Excel and Active Server Pages
-
Using XML in Excel 2016
