Microsoft Excel 2013 Programming by Example with VBA, XML, and ASP / / Julitta Korol.

• Superior document: Title is part of eBook package: De Gruyter Sciendo All Ebooks Trial Collection 2024
• VerfasserIn: Korol, Julitta,
• Place / Publishing House: Dulles, VA : : Mercury Learning and Information, , [2014]; ©2014
• Year of Publication: 2014
• Language: English
• Physical Description: 1 online resource (800 p.)

This book is suitable for readers already familiar with the Excel user interface and introduces programming concepts via numerous multi-step, practical exercises. More advanced topics are introduced via custom projects. Covers recording and editing a macro and writing VBA code through working with XML documents and using ASP to display data on the Web. Microsoft Excel 2013 Programming by Example with VBA, XML and ASP is a practical how-to book on Excel programming, suitable for readers already familiar with the Excel user interface. The book introduces programming concepts via numerous multi-step, illustrated, hands-on exercises. More advanced topics are introduced via custom projects. From recording and editing a macro and writing VBA code to working with XML documents and using classic ASP to access and display data on the Web, this book takes you on a programming journey that will change the way you work with Excel. Completely updated for Excel 2010, this 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 programming advanced Excel features such as PivotTables, PivotCharts, and SmartTags. The chapters are loaded with illustrated hands-on projects and exercises that tell you exactly where to enter code, how to debug it, and then run it. Each exercise/project step is clearly explained as it is performed. Features: Explores in great detail the latest version of Excel and all of its features. Covers recording and editing a macro and writing VBA code through working with XL documents and using ASP to display data on the Web. Covers Office Web Apps.

Table of Contents

Frontmatter -- Contents -- Acknowledgments -- Introduction -- Part I—Introduction to Excel 2013 VBA Programming -- Chapter 1: Automating Worksheet Tasks with Macros -- Chapter 2: Exploring the Visual Basic Editor (VBE) -- Chapter 3: Excel VBA Fundamentals -- Chapter 4: Using Variables, Data Types, and Constants -- Chapter 5: VBA Procedures: Subroutines and Functions -- Part II—Controlling Program Execution -- Chapter 6: Decision Making with VBA -- Chapter 7: Repeating Actions in VBA -- Part III—Keeping Track of Multiple Values -- Chapter 8: Working with Arrays -- Chapter 9: Working with Collections and Class Modules -- Part IV—Error Handling and Debugging -- Chapter 10: VBE Tools for Testing and Debugging -- Chapter 11: Conditional Compilation and Error Trapping -- Part V—Manipulating Files and Folders with VBA -- Chapter 12: File and Folder Manipulation with VBA -- Chapter 13: File and Folder Manipulation with Windows Script Host (WSH) -- Chapter 14: Using Low-Level File Access -- Part VI—Controlling Other Applications with VBA -- Chapter 15: Using Excel VBA to Interact with Other Applications -- Chapter 16: Using Excel with Microsoft Access -- Part VII—Enhancing the User Experience -- Chapter 17: Event-Driven Programming -- Chapter 18: Using Dialog Boxes -- Chapter 19: Creating Custom Forms -- Chapter 20: Formatting Worksheets with VBA -- Chapter 21: Context Menu Programming and Ribbon Customizations -- Part VIII—Programming Excel Special Features -- Chapter 22: Printing and Sending Email from Excel -- Chapter 23: Programming PivotTables and PivotCharts -- Chapter 24: Using and Programming Excel Tables -- Chapter 25: Programming Special Features -- Chapter 26: Programming the Visual Basic Editor (VBE) -- Part IX—Excel and Web Technologies -- Chapter 27: HTML Programming and Web Queries -- Chapter 28: Excel and Active Server Pages -- Chapter 29: Using XML in Excel 2013 -- Part X Going Beyond the Limits of VBA -- Chapter 30: Calling Windows API Functions from VBA -- Index