[et_pb_section fb_built="1" custom_padding_last_edited="on|tablet" admin_label="Section" module_class="wfocu-divi-fullwidth" _builder_version="4.6.6" background_enable_color="off" background_image="http://excelvbaisfun.com/wp-content/uploads/2021/11/magnetic_upsell.jpg" background_position="top_left" background_blend="multiply" custom_padding="6px|0px|5px|0px|false|false" custom_padding_tablet="6px|20px|5px|20px|false|false" custom_padding_phone="7px||||false|false" locked="off" collapsed="on" global_colors_info="{}"][et_pb_row custom_padding_last_edited="on|phone" _builder_version="4.7.7" custom_margin="0px|auto||auto|false|false" custom_margin_tablet="" custom_margin_phone="" custom_margin_last_edited="on|phone" custom_padding="8px||83px||false|false" custom_padding_tablet="||74px||false|false" custom_padding_phone="7px|0px|38px|0px|false|false" global_colors_info="{}"][et_pb_column type="4_4" _builder_version="4.0.2" global_colors_info="{}"][et_pb_image src="http://excelvbaisfun.com/wp-content/uploads/2021/11/Logo-no-tagline200wht.png" title_text="Logo no tagline200wht" align="center" _builder_version="4.12.1" custom_margin="-3px||6px||false|false" custom_margin_tablet="||55px||false|false" custom_margin_phone="||50px||false|false" custom_margin_last_edited="on|tablet" custom_padding="6px|||||" global_colors_info="{}"][/et_pb_image][et_pb_text _builder_version="4.12.1" text_font="Roboto||||||||" text_text_color="#FFFFFF" text_font_size="50px" text_line_height="65px" text_orientation="center" custom_margin="||9px||false|false" custom_margin_tablet="||27px||false|false" custom_margin_phone="||16px||false|false" custom_margin_last_edited="on|tablet" custom_padding="0px||4px||false|false" hover_enabled="0" text_font_size_tablet="32px" text_font_size_phone="22px" text_font_size_last_edited="on|phone" text_line_height_tablet="" text_line_height_phone="33px" text_line_height_last_edited="on|phone" global_colors_info="{}" sticky_enabled="0"]
Wait! Here's a One-Time Offer: Web Automation with Excel
[/et_pb_text][et_pb_text _builder_version="4.12.1" text_font="Roboto|300|||||||" text_text_color="#ffffff" text_font_size="18px" header_text_align="center" text_orientation="center" custom_margin="-10px||13px||false|false" custom_margin_tablet="||29px||false|false" custom_margin_phone="||22px||false|false" custom_margin_last_edited="on|tablet" custom_padding="||||false|false" text_font_size_tablet="18px" text_font_size_phone="16px" text_font_size_last_edited="on|tablet" text_line_height_tablet="" text_line_height_phone="25px" text_line_height_last_edited="on|phone" border_radii="on|50px|50px|50px|50px" global_colors_info="{}"]
What if you could Completely Control Websites with Excel?...
[/et_pb_text][et_pb_video src="https://vimeo.com/643660525/ad44ba949d" _builder_version="4.12.1" max_width="2000px" max_width_tablet="100%" max_width_phone="" max_width_last_edited="on|tablet" module_alignment="center" max_height="1000px" custom_margin="-1px|0px|15px|0px|false|false" custom_margin_tablet="||19px||false|false" custom_margin_phone="-2px||20px||false|false" custom_margin_last_edited="on|phone" custom_padding="|0px||0px|false|false" hover_enabled="0" global_colors_info="{}" width="85%" sticky_enabled="0"][/et_pb_video][et_wfocu_accept_button text="Upgrade Now" wfocu_accept_buttontitle_typography_font_size="32px" wfocu_accept_buttontitle_typography_typograhy="Roboto|300|||||||" wfocu_accept_button_button_text_color="#FFFFFF" wfocu_accept_button_background_color="#ff7800" wfocu_accept_button_accept_button_hover_color="#FFFFFF" wfocu_accept_button_button_background_hover_color="#CB6103" wfocu_accept_button_border_border_radius_top="50" wfocu_accept_button_border_border_radius_bottom="50" wfocu_accept_button_border_border_radius_left="50" wfocu_accept_button_border_border_radius_right="50" wfocu_accept_button_box_shadow_shadow_enable="off" wfocu_accept_button_padding="21px|150px|25px|150px|false|true| 5px" wfocu_accept_buttontitle_typography_font_size_tablet="" wfocu_accept_buttontitle_typography_font_size_phone="27px" wfocu_accept_buttontitle_typography_font_size_last_edited="on|phone" wfocu_accept_button_padding_tablet="" wfocu_accept_button_padding_phone="12px|36px|14px|36px|false|true| 5px" wfocu_accept_button_padding_last_edited="on|phone" _builder_version="4.12.1" _module_preset="default" global_colors_info="{}"][/et_wfocu_accept_button][/et_pb_column][/et_pb_row][/et_pb_section][et_pb_section fb_built="1" custom_padding_last_edited="on|tablet" module_class="wfocu-divi-fullwidth" _builder_version="4.6.6" background_color="#FFFFFF" custom_margin="-2px|0px||0px|false|false" custom_padding="76px||55px||false|false" custom_padding_tablet="51px|0px|0px|0px|false|false" custom_padding_phone="30px|15px|30px|15px|false|false" locked="off" collapsed="on" global_colors_info="{}"][et_pb_row custom_padding_last_edited="on|tablet" _builder_version="4.6.6" max_width="1140px" custom_margin="-2px|auto|-1px|auto|false|false" custom_margin_tablet="" custom_margin_phone="-3px||||false|false" custom_margin_last_edited="on|phone" custom_padding="0px||1px||false|false" custom_padding_tablet="0px|30px|1px|30px|false|false" custom_padding_phone="|0px||0px|false|false" global_colors_info="{}" custom_css_main_element_last_edited="on|desktop" custom_css_main_element_tablet="min-width:auto;" custom_css_main_element_phone="min-width:auto;"][et_pb_column type="4_4" _builder_version="4.0.2" global_colors_info="{}"][et_pb_text _builder_version="4.12.1" text_font="Roboto||||||||" text_text_color="#707070" text_font_size="15px" header_2_font="Roboto|700|||||||" header_2_text_color="#2c2c2c" header_2_font_size="24px" header_2_line_height="1.7em" custom_margin="7px||21px||false|false" custom_margin_tablet="" custom_margin_phone="7px||20px||false|false" custom_margin_last_edited="on|phone" text_font_size_tablet="" text_font_size_phone="14px" text_font_size_last_edited="on|phone" text_line_height_tablet="" text_line_height_phone="26px" text_line_height_last_edited="on|phone" header_2_font_size_tablet="" header_2_font_size_phone="22px" header_2_font_size_last_edited="on|phone" header_2_line_height_tablet="" header_2_line_height_phone="26px" header_2_line_height_last_edited="on|phone" global_colors_info="{}"]
Complete Web Automation With Excel VBA
Fill out web forms dynamically, navigate web pages intuitively, and extract and manipulate data to increase efficiency.
[/et_pb_text][/et_pb_column][/et_pb_row][et_pb_row _builder_version="4.11.4" _module_preset="default" width="100%" global_colors_info="{}" column_structure="1_3,1_3,1_3" background_enable_image="off" width_tablet="100%" width_phone="100%" width_last_edited="on|desktop" locked="off" custom_padding="16px||11px|||"][et_pb_column type="1_3" _builder_version="4.11.4" _module_preset="default" global_colors_info="{}"][et_pb_text _builder_version="4.12.1" text_font="Libre Baskerville||||||||" text_text_color="rgba(24,39,57,0.94)" text_line_height="26px" ul_font="Libre Baskerville|300|||||||" ul_text_color="rgba(24,39,57,0.94)" ul_font_size="16px" ul_line_height="26px" custom_padding="|||94px|false|false" custom_padding_tablet="" custom_padding_phone="|||0px|false|false" custom_padding_last_edited="on|phone" ul_text_align_tablet="left" ul_text_align_phone="left" ul_text_align_last_edited="on|tablet" ul_font_size_tablet="16px" ul_font_size_phone="" ul_font_size_last_edited="on|tablet" locked="off" global_colors_info="{}"]
- Input Text & Run Searches
- Scrape Web Data
- Manipulate Web Elements
- Image/Clipboard Manipulation
[/et_pb_text][/et_pb_column][et_pb_column type="1_3" _builder_version="4.11.4" _module_preset="default" global_colors_info="{}"][et_pb_text _builder_version="4.12.1" text_font="Libre Baskerville||||||||" text_text_color="rgba(24,39,57,0.94)" text_line_height="26px" ul_font="Libre Baskerville|300|||||||" ul_text_color="rgba(24,39,57,0.94)" ul_font_size="16px" ul_line_height="26px" custom_padding="|||94px|false|false" custom_padding_tablet="" custom_padding_phone="|||0px|false|false" custom_padding_last_edited="on|phone" ul_text_align_tablet="left" ul_text_align_phone="left" ul_text_align_last_edited="on|tablet" ul_font_size_tablet="16px" ul_font_size_phone="" ul_font_size_last_edited="on|tablet" locked="off" global_colors_info="{}"]
- Fill Forms & Dynamically Wait
- Options and Selection Controls
- Hover & Click Actions
- Change Value, Class or Any Attribute!
[/et_pb_text][/et_pb_column][et_pb_column type="1_3" _builder_version="4.11.4" _module_preset="default" global_colors_info="{}"][et_pb_text _builder_version="4.12.1" text_font="Libre Baskerville||||||||" text_text_color="rgba(24,39,57,0.94)" text_line_height="26px" ul_font="Libre Baskerville|300|||||||" ul_text_color="rgba(24,39,57,0.94)" ul_font_size="16px" ul_line_height="26px" custom_padding="|||94px|false|false" custom_padding_tablet="" custom_padding_phone="|||0px|false|false" custom_padding_last_edited="on|phone" hover_enabled="0" ul_text_align_tablet="left" ul_text_align_phone="left" ul_text_align_last_edited="on|tablet" ul_font_size_tablet="16px" ul_font_size_phone="" ul_font_size_last_edited="on|tablet" locked="off" global_colors_info="{}" sticky_enabled="0"]
- Navigate Pagination
- Drag & Drop Programmatically
- Dialog Boxes and Popups
- Window Sizing and Positioning
[/et_pb_text][/et_pb_column][/et_pb_row][et_pb_row custom_padding_last_edited="on|tablet" _builder_version="4.6.6" max_width="1140px" custom_margin="-2px|auto|-1px|auto|false|false" custom_margin_tablet="" custom_margin_phone="-3px||||false|false" custom_margin_last_edited="on|phone" custom_padding="0px||1px||false|false" custom_padding_tablet="0px|30px|1px|30px|false|false" custom_padding_phone="|0px||0px|false|false" hover_enabled="0" global_colors_info="{}" custom_css_main_element_last_edited="on|desktop" custom_css_main_element_tablet="min-width:auto;" custom_css_main_element_phone="min-width:auto;" sticky_enabled="0"][et_pb_column type="4_4" _builder_version="4.0.2" global_colors_info="{}"][et_pb_text _builder_version="4.12.1" text_font="Roboto||||||||" text_text_color="#707070" text_font_size="23px" header_2_font="Roboto|700|||||||" header_2_text_color="#2c2c2c" header_2_font_size="39px" header_2_line_height="1.7em" custom_margin="7px||1px||false|false" custom_margin_tablet="" custom_margin_phone="7px||20px||false|false" custom_margin_last_edited="on|phone" hover_enabled="0" text_font_size_tablet="" text_font_size_phone="14px" text_font_size_last_edited="on|phone" text_line_height_tablet="" text_line_height_phone="26px" text_line_height_last_edited="on|phone" header_2_font_size_tablet="" header_2_font_size_phone="22px" header_2_font_size_last_edited="on|phone" header_2_line_height_tablet="" header_2_line_height_phone="26px" header_2_line_height_last_edited="on|phone" global_colors_info="{}" sticky_enabled="0" text_orientation="center"]
Get Started in 3 Easy Steps
[/et_pb_text][/et_pb_column][/et_pb_row][et_pb_row column_structure="1_3,2_3" custom_padding_last_edited="on|phone" _builder_version="4.12.1" custom_margin="2px|auto|10px|auto|false|false" custom_margin_tablet="16px||0px||false|false" custom_margin_phone="20px||-40px||false|false" custom_margin_last_edited="on|desktop" custom_padding="8px|20px|17px|20px|false|false" custom_padding_tablet="|30px||30px|false|false" custom_padding_phone="|0px||0px|false|false" hover_enabled="0" global_colors_info="{}" custom_css_main_element_last_edited="on|desktop" sticky_enabled="0"][et_pb_column type="1_3" _builder_version="4.6.6" global_colors_info="{}"][et_pb_image src="http://excelvbaisfun.com/wp-content/uploads/2019/04/Web_Automation_With_Excel_VBA2-FINAL-elmalak.png" title_text="Web_Automation_With_Excel_VBA2 FINAL elmalak" align="center" _builder_version="4.12.1" custom_margin="|0px||0px|false|false" custom_padding="5px|0px||0px|false|false" border_radii="on|15px|15px|15px|15px" border_radii_tablet="" border_radii_phone="" border_radii_last_edited="on|phone" global_colors_info="{}"][/et_pb_image][/et_pb_column][et_pb_column type="2_3" _builder_version="4.6.6" custom_padding_tablet="" custom_padding_phone="|5px||5px|false|false" custom_padding_last_edited="on|phone" global_colors_info="{}"][et_pb_blurb title="Step 1: Install Selenium Free" use_icon="on" font_icon="%%3%%" icon_color="#d01f1f" icon_placement="left" content_max_width="1030px" content_max_width_tablet="100%" content_max_width_phone="" content_max_width_last_edited="on|tablet" _builder_version="4.7.7" header_level="h2" header_font="Roboto||||||||" header_text_color="#2c2c2c" header_font_size="16px" header_line_height="1.7em" body_font="Roboto||||||||" body_text_color="#707070" body_font_size="15px" width="100%" max_width_tablet="100%" max_width_phone="" max_width_last_edited="on|tablet" custom_margin="||5px||false|false" custom_margin_tablet="" custom_margin_phone="||4px||false|false" custom_margin_last_edited="on|phone" custom_padding="||20px||false|false" animation="off" header_line_height_tablet="" header_line_height_phone="1.5em" header_line_height_last_edited="on|phone" body_font_size_tablet="" body_font_size_phone="14px" body_font_size_last_edited="on|phone" body_line_height_tablet="" body_line_height_phone="26px" body_line_height_last_edited="on|phone" global_colors_info="{}"]
We walk you through everything and it's super easy. With our easy installer, you get all the web browsers and everything you need in one easy step.
[/et_pb_blurb][et_pb_blurb title="Step 2: Identifying and Manipulating Web Elements" use_icon="on" font_icon="%%3%%" icon_color="#d01f1f" icon_placement="left" content_max_width="1030px" content_max_width_tablet="100%" content_max_width_phone="" content_max_width_last_edited="on|tablet" _builder_version="4.7.7" header_level="h2" header_font="Roboto||||||||" header_text_color="#2c2c2c" header_font_size="16px" header_line_height="1.7em" body_font="Roboto||||||||" body_text_color="#707070" body_font_size="15px" width="100%" max_width_tablet="100%" max_width_phone="" max_width_last_edited="on|tablet" custom_margin="||5px||false|false" custom_margin_tablet="" custom_margin_phone="||4px||false|false" custom_margin_last_edited="on|phone" custom_padding="||20px||false|false" animation="off" hover_enabled="0" header_line_height_tablet="" header_line_height_phone="1.5em" header_line_height_last_edited="on|phone" body_font_size_tablet="" body_font_size_phone="14px" body_font_size_last_edited="on|phone" body_line_height_tablet="" body_line_height_phone="26px" body_line_height_last_edited="on|phone" global_colors_info="{}" sticky_enabled="0"]
We'll take you from basic strategies like ID, Name, Tag and Class - to advanced strategies like using XPath, CSS and utilizing Regular Expression (RegEx) patterns.
[/et_pb_blurb][et_pb_blurb title="Step 3: So Many Ways to Manipulate a Web Browser!" use_icon="on" font_icon="%%3%%" icon_color="#d01f1f" icon_placement="left" content_max_width="1030px" content_max_width_tablet="100%" content_max_width_phone="" content_max_width_last_edited="on|tablet" _builder_version="4.7.7" header_level="h2" header_font="Roboto||||||||" header_text_color="#2c2c2c" header_font_size="16px" header_line_height="1.7em" body_font="Roboto||||||||" body_text_color="#707070" body_font_size="15px" width="100%" max_width_tablet="100%" max_width_phone="" max_width_last_edited="on|tablet" custom_margin="||4px|||" custom_padding="||20px||false|false" animation="off" header_line_height_tablet="" header_line_height_phone="1.5em" header_line_height_last_edited="on|phone" body_font_size_tablet="" body_font_size_phone="14px" body_font_size_last_edited="on|phone" body_line_height_tablet="" body_line_height_phone="26px" body_line_height_last_edited="on|phone" global_colors_info="{}"]
Once you know how to capture an element, now you can use it! You'll learn to scrape and parse web data, capture groups of elements into arrays, lists or Excel. You'll be able to log in to websites automatically, performs tests, use images of web elements or pages on your computer or in Excel. Basically anything a person can do, you can make Excel do online for you!
[/et_pb_blurb][/et_pb_column][/et_pb_row][et_pb_row custom_padding_last_edited="on|phone" _builder_version="4.7.7" custom_margin="26px|auto|10px|auto|false|false" custom_margin_tablet="16px||0px||false|false" custom_margin_phone="20px||-40px||false|false" custom_margin_last_edited="on|desktop" custom_padding="8px|20px||20px|false|false" custom_padding_tablet="|30px||30px|false|false" custom_padding_phone="|0px||0px|false|false" hover_enabled="0" global_colors_info="{}" custom_css_main_element_last_edited="on|desktop" sticky_enabled="0"][et_pb_column type="4_4" _builder_version="4.6.6" global_colors_info="{}"][et_pb_divider color="#d01f1f" divider_weight="2px" _builder_version="4.6.6" width="275px" module_alignment="center" min_height="9px" custom_margin="1px||11px||false|false" custom_margin_tablet="" custom_margin_phone="1px||7px||false|false" custom_margin_last_edited="on|phone" custom_padding="||2px|||" global_colors_info="{}"][/et_pb_divider][et_pb_text _builder_version="4.12.1" text_text_color="#FFFFFF" header_4_font="Roboto|900|||||||" header_4_text_align="center" header_4_text_color="#000000" header_4_font_size="38px" header_4_line_height="28px" text_orientation="center" hover_enabled="0" locked="off" global_colors_info="{}" sticky_enabled="0" header_font_size="48px" header_2_font_size="42px"]
Full Course TOC:
[/et_pb_text][et_pb_toggle title="Introduction - Getting Started & Setup" open_toggle_background_color="#f4f4f4" closed_toggle_background_color="#ffffff" icon_color="#0c71c3" use_icon_font_size="on" icon_font_size="25px" _builder_version="4.4.7" title_text_color="#1a1a1a" title_font="Roboto||||||||" title_font_size="26px" title_line_height="35px" body_font="Libre Baskerville||||||||" body_text_color="rgba(24,39,57,0.94)" body_line_height="26px" border_width_all="0px" border_width_bottom="2px" locked="off" global_colors_info="{}"]
- Introduction and Course Download Files
- Getting & Installing Selenium
- Installation Troubleshooting (skip if you don't need this!)
[/et_pb_toggle][et_pb_toggle title="Selenium Basics" open_toggle_background_color="#f4f4f4" closed_toggle_background_color="#ffffff" icon_color="#0c71c3" use_icon_font_size="on" icon_font_size="25px" _builder_version="4.4.7" title_text_color="#1a1a1a" title_font="Roboto||||||||" title_font_size="26px" title_line_height="35px" body_font="Libre Baskerville||||||||" body_text_color="rgba(24,39,57,0.94)" body_line_height="26px" border_width_all="0px" border_width_bottom="2px" locked="off" global_colors_info="{}"]
- Opening a Web Page
- Web Elements 101 - Type in Textbox and Click Search Button (ID,Name Selectors)
- HTML Overview - Popular Tags and Attributes
- Strategies - "Tag"
- Awful-Valentine Site Expired, But We Downloaded It!
- Strategies - "Class"
- Exercise 02a - Question
- Exercise 02a - Answer
- Strategies - "LinkText"
- Looking At Attributes - More Than Just TEXT!
- Strategies - "PartialLinkText"
- Strategies - "CSS Selectors" Intro
- How to Install a Chrome Extension
- CSS Selector Helper for Chrome
- CSS Selector Tool - ChroPath and Technical Demonstration
- BONUS - Set Value versus SendKeys To TextBox
- BONUS - Create of Change Any Attribute Using Javascript
- BONUS - New Change Attribute Custom Function and Huge Demo
- Set Attributes With JavaScript Easily!
[/et_pb_toggle][et_pb_toggle title="Advanced Find With XPath" open_toggle_background_color="#f4f4f4" closed_toggle_background_color="#ffffff" icon_color="#0c71c3" use_icon_font_size="on" icon_font_size="25px" _builder_version="4.4.7" title_text_color="#1a1a1a" title_font="Roboto||||||||" title_font_size="26px" title_line_height="35px" body_font="Libre Baskerville||||||||" body_text_color="rgba(24,39,57,0.94)" body_line_height="26px" border_width_all="0px" border_width_bottom="2px" locked="off" global_colors_info="{}"]
- Introduction to XPath
- XPath Helper Tool
- ChroPath with XPath for Relative and Absolute Reference Types
- XPath Function - Contains()
- XPath Function - Text()
- XPath Function - AND, OR
- XPath Function - Starts-With()
- XPath - Axes
- XPath Function - Last()
- Selecting a Specific Index for XPath Query!
- Exercise 03a - Question
- Exercise 03a - Answer
- More XPath Resources
- Selenium VBA Code Snippets - Chapter 1-3
[/et_pb_toggle][et_pb_toggle title="Working With Multiple Elements At Once" open_toggle_background_color="#f4f4f4" closed_toggle_background_color="#ffffff" icon_color="#0c71c3" use_icon_font_size="on" icon_font_size="25px" _builder_version="4.4.7" title_text_color="#1a1a1a" title_font="Roboto||||||||" title_font_size="26px" title_line_height="35px" body_font="Libre Baskerville||||||||" body_text_color="rgba(24,39,57,0.94)" body_line_height="26px" border_width_all="0px" border_width_bottom="2px" locked="off" global_colors_info="{}"]
- Working With a Group Of Elements (FindElements)
- Looping Through a Set of Elements, Declaration Tips
- Grab the Text For Each Element Into A List
- Grabbing All Attribute Values into a List
- Add, Remove or Change an Element from a List
- Get Count of List Items or Web Elements
- Remove Duplicates Elements from List
- Sorting Your List
- Importing Items to Excel Directly!
- Looping Through a List of Attributes for a Set of Elements
- Exercise 04a - Question
- Exercise 04a - Answer
- Finding Elements within an Element
[/et_pb_toggle][et_pb_toggle title="Element Properties, Methods and Useful Information" open_toggle_background_color="#f4f4f4" closed_toggle_background_color="#ffffff" icon_color="#0c71c3" use_icon_font_size="on" icon_font_size="25px" _builder_version="4.4.7" title_text_color="#1a1a1a" title_font="Roboto||||||||" title_font_size="26px" title_line_height="35px" body_font="Libre Baskerville||||||||" body_text_color="rgba(24,39,57,0.94)" body_line_height="26px" border_width_all="0px" border_width_bottom="2px" locked="off" global_colors_info="{}"]
- Find the Active Element
- Understanding the 'By' Object
- Does The Element Exist Using 'By' Object
- Does Element Exist Using WebElement Object (2 Ways!)
- Value, Tagname, Text & Css Properties
- Specialty Text Variations
- Discover Whether Element is Displayed, Enabled, Present, Selected...
- Pagination - Clicking Next Until You Reach the Last Page
- Element Position and Size
- Scrolling Element Into View
- Regular Expression Patterns!
- Return Text Based on Regular Expression (RegEx)
- Automatically Download File to Custom Folders with SetPreference()
- SetPreference Extra example!
[/et_pb_toggle][et_pb_toggle title="Built In Comparison Operators" open_toggle_background_color="#f4f4f4" closed_toggle_background_color="#ffffff" icon_color="#0c71c3" use_icon_font_size="on" icon_font_size="25px" _builder_version="4.4.7" title_text_color="#1a1a1a" title_font="Roboto||||||||" title_font_size="26px" title_line_height="35px" body_font="Libre Baskerville||||||||" body_text_color="rgba(24,39,57,0.94)" body_line_height="26px" border_width_all="0px" border_width_bottom="2px" locked="off" global_colors_info="{}"]
- Assert vs Verify
- Equals Comparison Operator
- Not Equals
- Contains
- Custom Error Messages
- Matches & NotMatches
- Fail, False and True
- Selenium VBA Code Snippets - Chapter 4-6
[/et_pb_toggle][et_pb_toggle title="Mouse and Keyboard Actions" open_toggle_background_color="#f4f4f4" closed_toggle_background_color="#ffffff" icon_color="#0c71c3" use_icon_font_size="on" icon_font_size="25px" _builder_version="4.4.7" title_text_color="#1a1a1a" title_font="Roboto||||||||" title_font_size="26px" title_line_height="35px" body_font="Libre Baskerville||||||||" body_text_color="rgba(24,39,57,0.94)" body_line_height="26px" border_width_all="0px" border_width_bottom="2px" locked="off" global_colors_info="{}"]
- Click, Click and Hold, Release, Right Click & Double Click
- SendKeys and Keys Modifiers
- KeyDown, KeyUp
- Exercise 07a - Question
- Exercise 07a - Answer
- DragAndDrop - Swapping Elements, Better with JavaScript
- DragAndDrop - Element Disappears Once Dropped
- DragAndDrop - Dragging Text Programmatically
- DragAndDrop - Dragging File for Upload Programmatically
- Hover MenuItem and Click On Submenu Item
- Clear Out Text Entry Element
[/et_pb_toggle][et_pb_toggle title="Timeouts and Waits" open_toggle_background_color="#f4f4f4" closed_toggle_background_color="#ffffff" icon_color="#0c71c3" use_icon_font_size="on" icon_font_size="25px" _builder_version="4.4.7" title_text_color="#1a1a1a" title_font="Roboto||||||||" title_font_size="26px" title_line_height="35px" body_font="Libre Baskerville||||||||" body_text_color="rgba(24,39,57,0.94)" body_line_height="26px" border_width_all="0px" border_width_bottom="2px" locked="off" global_colors_info="{}"]
- TimeOuts and Wait DEFAULTS
- Basic Wait Command
- Exercise 08a - Question
- Exercise 08a - Answer
- Finding Elements With a Custom TimeOut Duration
- Wait Until Element is Displayed
- Wait For Specific Text or a Specific Attribute to Appear!
- Wait For CSS Special Value to Appear or Change
- Wait for Text To Appear or Change
- WaitNotElement and By.Any
- WaitEnabled or Wait Until Element is Displayed
- Wait For Selection With Checkboxes and OptionButtons
- Selenium VBA Code Snippets - Chapter 7-8
[/et_pb_toggle][et_pb_toggle title="Browser Window Control, Navigation and Focus" open_toggle_background_color="#f4f4f4" closed_toggle_background_color="#ffffff" icon_color="#0c71c3" use_icon_font_size="on" icon_font_size="25px" _builder_version="4.4.7" title_text_color="#1a1a1a" title_font="Roboto||||||||" title_font_size="26px" title_line_height="35px" body_font="Libre Baskerville||||||||" body_text_color="rgba(24,39,57,0.94)" body_line_height="26px" border_width_all="0px" border_width_bottom="2px" locked="off" global_colors_info="{}"]
- Alerts - Using Multi Options (OK and Cancel, OK Only & Text) with An Alert
- SetCredentials Troubleshooting Tips and Authorization Dialog Popups
- Custom Function Testing Whether Dialog Popup Is Present
- Basic Navigation - Back, Forward, Reload, Close Driver, Close Single page, Url
- Setting A Custom Profile For WebDriver Session
- Add Special Arguments to Customize Browser Options - Incognito or Hidden Window
- Special Arguments List
- Using a Portable Version of Chrome - GoogleChromePortable
- AddArguments Link and Examples
- Grab Html Page Source and Text From Parent Elements
- Exercise 09a - Question
- Exercise 09a - Answer
- Keep a Permanent WebDriver that Doesn't Close On Its Own
- Frames and Frame Nagivation
- BONUS - Frame Finder Custom Function
- BONUS - Switch To Nested Frame Custom Function
- Window, Tab Manipulation by Title, Index, Previous and Next
- Accessing Window By Name, Handle
- Close All Tabs Except Main Tab
- Several Ways To Open a New Tab In Current Session
- Window Sizing and Position
- Selenium VBA Code Snippets - Chapter 9
[/et_pb_toggle][et_pb_toggle title="Image and Clipboard Manipulation" open_toggle_background_color="#f4f4f4" closed_toggle_background_color="#ffffff" icon_color="#0c71c3" use_icon_font_size="on" icon_font_size="25px" _builder_version="4.4.7" title_text_color="#1a1a1a" title_font="Roboto||||||||" title_font_size="26px" title_line_height="35px" body_font="Libre Baskerville||||||||" body_text_color="rgba(24,39,57,0.94)" body_line_height="26px" border_width_all="0px" border_width_bottom="2px" locked="off" global_colors_info="{}"]
- Save a Screenshot of Your Browser, Dispose Image in System Memory
- Save Web Element as Image
- Save Entire Desktop Screen as Image
- Copy Image Directly to Excel OR To Clipboard
- Image Dimensions and Resizing
- Compare Two Images with CompareTo and DiffCount
- Put Web Image Into Worksheet ActiveX Image Control
- Load Image Into Userform Image
[/et_pb_toggle][et_pb_toggle title="Working With Tables" open_toggle_background_color="#f4f4f4" closed_toggle_background_color="#ffffff" icon_color="#0c71c3" use_icon_font_size="on" icon_font_size="25px" _builder_version="4.4.7" title_text_color="#1a1a1a" title_font="Roboto||||||||" title_font_size="26px" title_line_height="35px" body_font="Libre Baskerville||||||||" body_text_color="rgba(24,39,57,0.94)" body_line_height="26px" border_width_all="0px" border_width_bottom="2px" locked="off" global_colors_info="{}"]
- Converting a Web Table to TableElement Object and Inserting into Worksheet
- Manipulating TableElement Data as Array onto Worksheet
- Loop Through Elements in Specific Column Only
- Loop Through Multiple Specific Columns Using OR Operator
- Put Specific Columns into List Object, To Excel Easily
- Exercise 11a - Question
- Exercise 11a - Answer
[/et_pb_toggle][et_pb_toggle title="Selecting Options from Dropdowns and Listboxes" open_toggle_background_color="#f4f4f4" closed_toggle_background_color="#ffffff" icon_color="#0c71c3" use_icon_font_size="on" icon_font_size="25px" _builder_version="4.4.7" title_text_color="#1a1a1a" title_font="Roboto||||||||" title_font_size="26px" title_line_height="35px" body_font="Libre Baskerville||||||||" body_text_color="rgba(24,39,57,0.94)" body_line_height="26px" border_width_all="0px" border_width_bottom="2px" locked="off" global_colors_info="{}"]
- Declare SelectElement, Read and Write Dropdown Control
- Select Using the Index Number
- Select Using Internal Option Value
- All About The Options Collection
- Using The Mouse To Select Multiple Options
- Deselecting All Options or Specific Options
- Selenium VBA Code Snippets - Chapter 10-12
- Exercise 12a - Question
- Exercise 12a - Answer
[/et_pb_toggle][et_pb_toggle title="BONUS - Extra Troubleshooting Tips" open_toggle_background_color="#f4f4f4" closed_toggle_background_color="#ffffff" icon_color="#0c71c3" use_icon_font_size="on" icon_font_size="25px" _builder_version="4.4.7" title_text_color="#1a1a1a" title_font="Roboto||||||||" title_font_size="26px" title_line_height="35px" body_font="Libre Baskerville||||||||" body_text_color="rgba(24,39,57,0.94)" body_line_height="26px" border_width_all="0px" border_width_bottom="2px" locked="off" global_colors_info="{}"]
- Error Loading Extension Help
- Error Loading Extension Help - Source Code
- BONUS LECTURE
[/et_pb_toggle][/et_pb_column][/et_pb_row][/et_pb_section][et_pb_section fb_built="1" custom_padding_last_edited="on|tablet" module_class="wfocu-divi-fullwidth" _builder_version="4.6.6" background_color="#f3f3f3" custom_padding="29px||57px|||" custom_padding_tablet="17px|15px|32px|15px|false|false" custom_padding_phone="" locked="off" global_colors_info="{}"][et_pb_row custom_padding_last_edited="on|phone" _builder_version="4.7.7" custom_padding="||46px||false|false" custom_padding_tablet="" custom_padding_phone="20px||19px||false|false" global_colors_info="{}" custom_css_main_element_last_edited="on|desktop" custom_css_main_element_tablet="min-width:auto;" custom_css_main_element_phone="min-width:auto;"][et_pb_column type="4_4" _builder_version="4.0.2" global_colors_info="{}"][et_pb_text _builder_version="4.7.7" header_font="Roboto||||||||" header_2_font="Roboto||||||||" header_2_text_align="center" header_2_text_color="#000000" header_2_font_size="40px" header_2_line_height="1.4em" min_height="52px" custom_margin="-2px||15px||false|false" custom_margin_tablet="-2px||21px||false|false" custom_margin_phone="||-4px||false|false" custom_margin_last_edited="on|tablet" custom_padding="0px||0px||false|false" header_2_font_size_tablet="30px" header_2_font_size_phone="24px" header_2_font_size_last_edited="on|tablet" global_colors_info="{}"]
This Exclusive Offer is Only Available On This Page
[/et_pb_text][et_pb_text _builder_version="4.7.7" text_font="Roboto||||||||" text_text_color="#707070" text_font_size="15px" header_2_font="Roboto|700|||||||" header_2_text_align="center" header_2_text_color="#2c2c2c" header_2_font_size="24px" header_2_line_height="1.2em" custom_margin="||11px|||" custom_margin_tablet="-2px||11px||false|false" custom_margin_phone="18px||7px||false|false" custom_margin_last_edited="on|tablet" header_2_font_size_tablet="24px" header_2_font_size_phone="26px" header_2_font_size_last_edited="on|tablet" global_colors_info="{}"]
Lifetime Membership
[/et_pb_text][et_pb_text _builder_version="4.12.1" text_font="Roboto||||||||" text_text_color="#707070" text_line_height="26px" text_orientation="center" max_width="760px" module_alignment="center" custom_margin="2px||22px||false|false" hover_enabled="0" text_font_size_tablet="15px" text_font_size_phone="14px" text_font_size_last_edited="on|tablet" global_colors_info="{}" sticky_enabled="0"]
You'll be able to access the course materials, bonus materials and upgrades to the course for life as well as access to the instructor and other students for support for life - all for a one-time fee.
[/et_pb_text][et_pb_text _builder_version="4.12.1" text_font="Roboto|700|||||||" text_text_color="#2c2c2c" text_font_size="15px" text_orientation="center" custom_margin="||33px||false|false" custom_margin_tablet="||23px||false|false" custom_margin_phone="" custom_margin_last_edited="on|tablet" global_colors_info="{}"]
Upgrade for only $27 (Lifetime Membership)
[/et_pb_text][et_wfocu_accept_button text="Upgrade Now" wfocu_accept_buttontitle_typography_font_size="32px" wfocu_accept_buttontitle_typography_typograhy="Roboto|300|||||||" wfocu_accept_button_button_text_color="#FFFFFF" wfocu_accept_button_background_color="#ff7800" wfocu_accept_button_accept_button_hover_color="#FFFFFF" wfocu_accept_button_button_background_hover_color="#CB6103" wfocu_accept_button_border_border_radius_top="50" wfocu_accept_button_border_border_radius_bottom="50" wfocu_accept_button_border_border_radius_left="50" wfocu_accept_button_border_border_radius_right="50" wfocu_accept_button_box_shadow_shadow_enable="off" wfocu_accept_button_padding="19px|150px|19px|150px| 5px |true| 5px" wfocu_accept_buttontitle_typography_font_size_tablet="" wfocu_accept_buttontitle_typography_font_size_phone="20px" wfocu_accept_buttontitle_typography_font_size_last_edited="on|phone" wfocu_accept_button_padding_tablet="" wfocu_accept_button_padding_phone="14px|81px|15px|81px|false|true| 5px" wfocu_accept_button_padding_last_edited="on|phone" _builder_version="4.7.7" _module_preset="default" locked="off" global_colors_info="{}"][/et_wfocu_accept_button][/et_pb_column][/et_pb_row][et_pb_row custom_padding_last_edited="on|phone" _builder_version="4.7.7" custom_margin="|auto|-1px|auto||" custom_padding="5px||2px||false|false" custom_padding_tablet="" custom_padding_phone="11px||2px||false|false" global_colors_info="{}"][et_pb_column type="4_4" _builder_version="4.0.2" global_colors_info="{}"][et_wfocu_reject_link text="No thanks. I don't want to make my life easier by putting my web interactions on auto-pilot. I hate easy things and saving money. Bring on the pain. :(" typography_font_size="15px" wfocu_reject_text_color="#2C2C2C" hover_color="#777777" _builder_version="4.12.1" _module_preset="default" hover_enabled="0" global_colors_info="{}" sticky_enabled="0"][/et_wfocu_reject_link][/et_pb_column][/et_pb_row][/et_pb_section][et_pb_section fb_built="1" custom_padding_last_edited="on|tablet" module_class="wfocu-divi-fullwidth" _builder_version="4.7.7" background_color="#1f1d27" custom_padding="18px|20px|9px|20px|false|false" custom_padding_tablet="0px||||false|false" custom_padding_phone="" saved_tabs="all" locked="off" global_colors_info="{}"][et_pb_row custom_padding_last_edited="on|tablet" _builder_version="4.6.6" max_width="1200px" custom_padding="0px||3px||false|false" custom_padding_tablet="0px||14px||false|false" custom_padding_phone="13px||17px||false|false" global_colors_info="{}" custom_css_main_element_last_edited="on|desktop" custom_css_main_element_tablet="min-width:auto;" custom_css_main_element_phone="min-width:auto;"][et_pb_column type="4_4" _builder_version="4.0.2" global_colors_info="{}"][et_pb_image src="http://excelvbaisfun.com/wp-content/uploads/2021/11/Logo-no-tagline200wht.png" title_text="Logo no tagline200wht" align="center" align_tablet="center" align_phone="" align_last_edited="on|tablet" _builder_version="4.12.1" custom_margin="||11px||false|false" custom_margin_tablet="40px||||false|false" custom_margin_phone="27px||12px||false|false" custom_margin_last_edited="on|tablet" global_colors_info="{}"][/et_pb_image][et_pb_text _builder_version="4.7.7" text_font="Roboto|300|||||||" text_text_color="#FFFFFF" link_font="Roboto||||||||" link_text_color="#FFFFFF" text_orientation="center" custom_margin="-3px||0px||false|false" custom_margin_tablet="" custom_margin_phone="-3px||0px||false|false" custom_margin_last_edited="on|phone" custom_padding="10px||||false|false" text_font_size_tablet="" text_font_size_phone="14px" text_font_size_last_edited="on|phone" text_orientation_tablet="center" text_orientation_phone="" text_orientation_last_edited="on|tablet" global_colors_info="{}"]
Privacy Policy | Terms & Condition
[/et_pb_text][et_pb_text _builder_version="4.6.6" text_font="Roboto||||||||" text_text_color="#FFFFFF" text_font_size="14.01px" header_2_font="Roboto||||||||" header_2_text_align="center" header_2_text_color="#FFFFFF" header_2_font_size="16px" text_orientation="center" custom_margin="0px||||false|false" custom_margin_tablet="2px||0px||false|false" custom_margin_phone="5px||||false|false" custom_margin_last_edited="on|tablet" custom_padding="14px||||false|false" custom_padding_tablet="13px||||false|false" custom_padding_phone="" custom_padding_last_edited="on|tablet" header_2_font_size_tablet="" header_2_font_size_phone="14px" header_2_font_size_last_edited="on|phone" global_colors_info="{}"]
© Copyright 2021 | All rights reserved
[/et_pb_text][/et_pb_column][/et_pb_row][/et_pb_section]
