Updated forExcel 2019 and based on the bestselling editions from
previous versions, MicrosoftExcel 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 otherMicrosoft Office
applications. It also covers proper use of event procedures, testing and
debugging, and guides you through programming advanced Excelfeatures
such as PivotTables, PivotCharts, 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 ObjectLibraries to access and manipulate data.
- Includeschapters on programming charts, PivotTables, dialog boxes,
custom forms, theRibbon, 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 info@merclearning.com)
- All source codeand supplemental files for the "Hands-On" exercises and
custom projects
- All images fromthe text (including 4-color screenshots)
