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 hugecourses.com.
View Sitemap