Automation using Macros & VBA




Automation using Macros & VBA

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

Automation using Macros & VBA

Url: View Details

What you will learn
  • Recording Macros
  • Understand Object Oriented concept
  • Know the basics of HTML pages and how to write code to get the data from the web

Rating: 5

Level: Intermediate Level

Duration: 11 hours

Instructor: Motasem Yakhola


Courses By:   0-9  A  B  C  D  E  F  G  H  I  J  K  L  M  N  O  P  Q  R  S  T  U  V  W  X  Y  Z 

About US

The display of third-party trademarks and trade names on this site does not necessarily indicate any affiliation or endorsement of coursescompany.com.


© 2021 coursescompany.com. All rights reserved.
View Sitemap