
Microsoft Excel 2019 Programming by Example with VBA, XML, and ASP
Description
Alles über E-Books | Antworten auf Fragen rund um E-Books, Kopierschutz und Dateiformate finden Sie in unserem Info- & Hilfebereich.
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)
More details
Other editions
Additional editions


System requirements
File format: PDF
Copy-Protection: Adobe-DRM (Digital Rights Management)
System requirements:
- Computer (Windows; MacOS X; Linux): Install the free reader Adobe Digital Editions prior to download (see eBook Help).
- Tablet/smartphone (Android; iOS): Install the free app Adobe Digital Editions or the app PocketBook before downloading (see eBook Help).
- E-reader: Bookeen, Kobo, Pocketbook, Sony, Tolino and many more (only limited: Kindle).
The file format PDF always displays a book page identically on any hardware. This makes PDF suitable for complex layouts such as those used in textbooks and reference books (images, tables, columns, footnotes). Unfortunately, on the small screens of e-readers or smartphones, PDFs are rather annoying, requiring too much scrolling.
This eBook uses Adobe-DRM, a „hard” copy protection. If the necessary requirements are not met, unfortunately you will not be able to open the eBook. You will therefore need to prepare your reading hardware before downloading.
Please note: We strongly recommend that you authorise using your personal Adobe ID after installation of any reading software.
For more information, see our eBook Help page.