Microsoft Excel 2019 : programming by example with VBA, XML, and ASP /

Bibliographic Details
Main Author:	Korol, Julitta (Author)
Corporate Author:	EBSCOhost
Format:	eBook
Language:	English
Published:	Dulles, Virginia : Mercury Learning and Information, [2019]
Subjects:	Microsoft Excel (Computer file) Microsoft Excel (Computer file) > Handbooks, manuals, etc. Active server pages. Electronic spreadsheets. Visual Basic for Applications (Computer program language) XML (Document markup language) Programming by example (Computer science) Electronic books.
Online Access:	Connect to the full text of this electronic book

Table of Contents:

Excel VBA primer. 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
Manipulating files and folders with VBA. File and folder manipulation with VBA ; File and folder manipulation with Windows Script Host (WSH) ; Using low-level file access
Controlling other applications with VBA. Using Excel VBA to interact with other applications ; Using Excel with Microsoft Access
Enhancing the user experience. 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
Excel tools for data analysis. Using and programming Excel tables ; Programming PivotTables and PivotCharts ; Getting and transforming data in Excel 2019
Taking charge of programming environment. Programming in the Visual Basic Editor (VBE) ; Calling Windows API functions from VBA
Excel and web technologies. HTML programming and web queries ; Excel and active server pages ; Using XML in Excel 2019.