Automation using Macros & VBA

Description

EXCEL VBA TRAINING OUTLINE

1. Recorded Macros

· Understanding Excel Macros

· Setting Macro Security

· Saving a Document as Macro Enabled

· Recording a Simple Macro

· Running a Recorded Macro

· Relative Cell References

· Running Macro with Relative References

· Viewing a Macro

· Editing a Macro

· Assigning a Macro to the controls

· Running a Macro from the controls

· Assigning a Keyboard Shortcut to a Macro

· Deleting a Macro

· Copying a Macro

2. Recorder Workshop

· Preparing Data for an Application

· Recording a Summation Macro

· Recording Consolidations

· Recording Divisional Macros

· Testing Macros

· Creating Objects to Run Macros

· Assigning a Macro to an Object

3. Understanding VBA

· Programming in Microsoft Excel

· VBA Terminology

· Understanding Objects

· Viewing the Excel Object Model

· Using the Immediate Window

· Setting Property Values

· Working with Worksheets

· The Best VBA Help Available

4. The VBA Editor

· The VBA Editor Screen

· Opening and Closing the Editor

· Using the Project Explorer

· Working with the Properties Window

· Using the Work Area

· Viewing Other Panes

· Working with Toolbars

· Working with a Code Module

· Running code from the Editor

· Setting Breakpoints in the Editor

· Stepping Through Code

5. Using Variables

· Understanding Variables

· Creating and Using Variables

· Implicit and Explicit Declarations

· The Scope of Variables

· Module Level Scoping

· Data Types

· Declaring Data types

6. Functions In VBA

· Understanding Functions

· Creating VBA Functions

· Using a VBA Function in a Worksheet

· Setting Function Data Types

· Using Multiple Arguments

· Modifying a VBA Function

· Importing a VBA Module

· Using a Function in VBA Code

7. Using Excel Objects

· The Application Object

· The Workbook Objects

· Program Testing with The Editor

· Using Workbook Objects

· The Worksheets Object

· Using the Worksheets Object

· The Range Object

· Using Range Objects

8. Programming Techniques

· The MsgBox Function

· Using MsgBox

· InputBox Techniques

· Using the InputBox Method

· The IF Statement

· Using IF for Single Conditions

· Using IF for multiple Conditions

· The Select Case Statement

· Using The Select Case Statement

· For Loops

· Looping With specified Iterations

· The Do...Loop Statement

· Looping With Unknown Iterations

9. Automatic Startup

· Programming Automatic Procedures

· Running Automatic Procedures

· Automatically Starting a Workbook

10. Error Handling

· Error types

· The On Error statement

· Creating a Simple Error Handler

· Using the Resume Statement

· Using Decision Structures in Error Handlers

· Using the Err object

11. Get Data From Web

· Introduction to HTML

· Introduction to Power query get from web

· Introduction to web reference library

· VBA Get items by (tags, class, name, id)

· Get data from souq as an example

TAKE THIS COURSE