Spreadsheet Automation (IS 520 - MBA 614, Winter 2016)
Sign Up
Chapter 28
Title Page
Introduction
Chapter 1: Getting Started – Learning About Macros
Chapter 2: Recording and Editing Macros for Complex Tasks
Chapter 3: Understanding Objects and Collections
Chapter 4: Writing Simple Macro Procedures
Chapter 5: Working with Ranges and Cells
Chapter 6: Understanding Data Types, Variables, and Constants
Chapter 7: Operators and Expressions
Chapter 8: Built-In Functions in VBA and Excel
Chapter 9: Using VBA Functions to Manipulate and Compare Strings
Chapter 10: Formatting Data Values
Chapter 11: Creating and Using Your Own Functions in VBA
Chapter 12: Creating Excel User-Defined Functions
Chapter 13: Making Decisions in VBA: Flow Control
Chapter 14: Repeating Actions in VBA: Loops
Chapter 15: Debugging and Testing VBA Code
Chapter 16: Working with Excel's Built-In Objects and Collections
Chapter 17: Working with Chart Objects
Chapter 18: Using Excel's Built-In File Dialogs
Chapter 19: Working With Pivot Tables
Chapter 20: Advanced Topics for Variables, Constants, and Data-Types
Chapter 21: Defensive Programming: Preventing Errors Before They Happen
Chapter 22: Error Handling
Chapter 23: Creating Libraries and Whole Programs: Modular Programming Techniques
Chapter 24: Creating and Using Arrays
Chapter 25: Sorting and Searching Arrays
Chapter 26: Creating Custom Dialogs with User Forms
Chapter 27: Creating Custom Ribbons for Your Workbooks
Chapter 28: Importing Data From A Database
Chapter 29: Using VBA to Control Internet Explorer
Chapter 30: Automating Solver With VBA
Chapter 31: Using the FollowHyperlink Method
Chapter 32: Using Event Procedures
Chapter 33: Creating, Deploying, and Controlling Add-Ins
Chapter 34: Creating Your Own Data Types
Chapter 35: Creating Your Own Classes and Collections
Chapter 36: Managing Files and Reading & Writing Text Files with VBA
Chapter 37: Working With Other Applications
Chapter 38: Using VBA to Send E-Mail with MS Outlook and Google Mail
Chapter 39: Using VBA to Control MS Word
Chapter 40: Using VBA with Google Docs
Chapter 41: Using VBA to Control MS PowerPoint
Login