Excel 2021 / Microsoft 365 Programming By Example / / Julitta Korol.

• VerfasserIn: Korol, Julitta,
• Place / Publishing House: Dulles, VA : : Mercury Learning and Information, , [2022]; ©2022
• Year of Publication: 2022
• Language: English
• Physical Description: 1 online resource (1072 p.)

Updated for Excel 2021 and based on the bestselling editions from previous versions, Excel 2021 / Microsoft 365 Programming by Example is a practical, how-to book on Excel programming, suitable for readers already proficient with the Excel user interface. If you are looking to automate Excel routine tasks, this book will progressively introduce you to programming concepts via numerous illustrated hands-on exercises. More advanced topics are demonstrated via custom projects. From recording and editing a macro and writing VBA code from scratch to programming the Ribbon interface and working with XML documents, this book takes you on a programming journey that will change the way you work with Excel. The book provides information 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 more advanced Excel features, such as working with VBA classes and raising your own events in standalone class modules. Includes companion files with source code, hands-on projects, and figures. FEATURES:Updated for Excel 2021 / Microsoft 365 and previous versionsIncludes 29 chapters and more than 275 applied examples and 10 projectsProvides a practical coverage of using Web queries, HTML, XML, and VBScriptCompanion files with color screen captures, source code, and projects in the text

Table of Contents

Frontmatter -- 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 ADVANCED CONCEPTS IN EXCEL VBA -- PART VIII WORKING TOGETHER: VBA, HTML, XML, AND THE REST API -- Index