Updated for Excel 2019 and based on the bestselling editions from previous versions, Microsoft Excel 2019 Programming by Example with VBA, XML and ASP is a practical, how-to book on Excel programming, suitable for readers already proficient withthe Excel user interface (UI). If you are looking to automate Excelroutine tasks, this book will progressively introduce you to programmingconcepts via numerous illustrated hands-on exercises. More advanced topics aredemonstrated via custom projects. From recording and editing a macro andwriting VBA code to working with XML documents and using Classic ASP pages toaccess and display data on the Web, this book takes you on a programmingjourney that will change the way you work with Excel. The book providesinformation on performing automatic operations on files, folders, and other Microsoft Office applications. It also covers proper use of event procedures, testing and debugging, and guides you through programming advanced Excelfeatures such as Pivot Tables, Pivot Charts, and the Ribbon interface.

Features:

• Contains 28chapters loaded with illustrated ‘Hands-On’ exercises and projectsthat guide you through the VBA programming language. Each example tells youexactly where to enter code, how to test it, and then run it.


• Takes you fromintroductory topics–including recording and editing macros, using variables, andconstants, writing subroutines/functions, conditional statements, and variousmethods of coding loops to repeat actions–to intermediate and advanced topicsthat include working with collections, class modules, arrays, file and databaseaccess, custom forms, error handling and debugging.


• Includescomprehensive coverage of native file handling in VBA, Windows Scripting Host(WSH), and low-level File Access.


• Demonstrates howto interact with Microsoft Access databases using both ADO and DAO Object Libraries to access and manipulate data.


• Includeschapters on programming charts, Pivot Tables, dialog boxes, custom forms, the Ribbon, Backstage View, context/shortcut menu customizations, as well as properuse of event procedures and callbacks.


• Provides a quick, “Hands-On” introduction to the data analysis and transformation processes usingthe Power Query feature and the “M” language formulas.


• Provides apractical coverage of using Web queries, HTML, XML, and VBScript in Classic ASPto retrieve and publish Excel data to the Web.

  ONTHE COMPANION FILES

(also available for download from the publisher by emailing proof of purchase to [email protected])

• All source codeand supplemental files for the “Hands-On” exercises and custom projects


• All images fromthe text (including 4-color screenshots)