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

Julitta Korol

• Éditeur: Mercury Learning and Information
• Année: 2019
• ISBN:
  9781683924012
• Sujet: Computer Science
• Sous-sujet: Desktop Applications

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 [email protected])

• All source codeand supplemental files for the "Hands-On" exercises and custom projects
• All images fromthe text (including 4-color screenshots)

Table des matières

• Cover page
• Title page
• Copyright
• Dedication
• Contents
• Acknowledgments
• Introduction
• Part I Excel VBA Primer
• Part II Manipulating Files and Folders with VBA
• Part III Controlling Other Applications with VBA
• Part IV Enhancing the User Experience
• Part V Excel Tools for Data Analysis
• Part VI Taking Charge of Programming Environment
• Part VII Excel and Web Technologies
• Index