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

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

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 X...

Full description

Saved in:
Bibliographic Details
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
Online Access:
Physical Description:1 online resource (800 p.)
Tags: Add Tag
No Tags, Be the first to tag this record!
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

Similar Items