GET ULTIMATE EXCEL

[et_pb_section fb_built=”1″ custom_padding_last_edited=”on|phone” disabled_on=”off|off|off” _builder_version=”4.12.1″ _module_preset=”default” background_color=”#2d2d2d” custom_margin=”||||true” custom_margin_tablet=”||||true” custom_margin_phone=”||||true” custom_margin_last_edited=”on|tablet” custom_padding=”0px||0px||true|false” custom_padding_tablet=”17px||17px||true|false” custom_padding_phone=”15px||15px||true|false” border_width_all=”4px” border_color_all=”#0C71C3″ border_style_all=”ridge” locked=”off” collapsed=”on” global_colors_info=”{}”][et_pb_row custom_padding_last_edited=”on|phone” _builder_version=”4.12.1″ _module_preset=”default” width=”90%” width_tablet=”90%” width_phone=”” width_last_edited=”on|desktop” max_width=”1600px” max_width_tablet=”1300px” max_width_phone=”” max_width_last_edited=”on|tablet” custom_margin=”||||false|false” custom_margin_tablet=”-6px||-12px||false|false” custom_margin_phone=”-3px||-11px||false|false” custom_margin_last_edited=”on|phone” custom_padding=”17px||10px|||” custom_padding_tablet=”0px||0px||true|false” custom_padding_phone=”” link_option_url=”/checkouts/uepc-checkout/” custom_css_main_element=”display: flex;” global_colors_info=”{}”][et_pb_column type=”4_4″ _builder_version=”4.9.4″ _module_preset=”default” 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.0″ _module_preset=”default” custom_margin=”-8px||-1px||false|false” global_colors_info=”{}” custom_padding__hover_enabled=”off|desktop”][/et_pb_image][/et_pb_column][/et_pb_row][/et_pb_section][et_pb_section fb_built=”1″ _builder_version=”4.11.4″ _module_preset=”default” use_background_color_gradient=”on” background_color_gradient_start=”#f7f7f7″ background_color_gradient_end=”#d7d7d7″ background_enable_image=”off” custom_margin_tablet=”” custom_margin_phone=”” custom_margin_last_edited=”on|phone” custom_padding=”0px||0px|0px|true|false” global_colors_info=”{}”][et_pb_row _builder_version=”4.9.4″ _module_preset=”default” background_enable_image=”off” width=”100%” width_tablet=”100%” width_phone=”100%” width_last_edited=”on|desktop” global_colors_info=”{}”][et_pb_column type=”4_4″ _builder_version=”4.9.4″ _module_preset=”default” global_colors_info=”{}”][et_pb_text _builder_version=”4.12.1″ _module_preset=”default” text_font=”Oswald|600|||||||” text_text_color=”#000000″ text_font_size=”36px” text_letter_spacing=”1px” text_line_height=”1.2em” text_orientation=”center” custom_margin=”|0px||0px|true|false” custom_margin_tablet=”|0px|||false|false” custom_margin_phone=”-13px||-4px||false|false” custom_margin_last_edited=”on|phone” text_text_color_last_edited=”off|phone” text_font_size_tablet=”” text_font_size_phone=”20px” text_font_size_last_edited=”on|phone” 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″ _module_preset=”default” width=”88%” module_alignment=”center” box_shadow_style=”preset2″ global_colors_info=”{}”][/et_pb_video][/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”][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 column_structure=”1_2,1_2″ _builder_version=”4.9.4″ width_tablet=”” width_phone=”90%” width_last_edited=”on|phone” custom_padding=”||16px|||” locked=”off” global_colors_info=”{}”][et_pb_column type=”1_2″ _builder_version=”4.4.7″ global_colors_info=”{}”][et_pb_text _builder_version=”4.4.7″ header_3_font=”Roboto|900|||||||” header_3_text_color=”#1a1a1a” header_3_font_size=”28px” header_3_line_height=”35px” header_3_font_size_tablet=”” header_3_font_size_phone=”25px” header_3_font_size_last_edited=”on|phone” global_colors_info=”{}”]

Lifetime Access for a one-time fee

[/et_pb_text][et_pb_text _builder_version=”4.12.1″ _module_preset=”default” text_font=”Roboto||||||||” text_font_size=”29px” custom_padding=”|15px|||false|false” text_font_size_tablet=”37px” text_font_size_phone=”27px” text_font_size_last_edited=”on|phone” locked=”off” global_colors_info=”{}”]

$54.00 $27.00

[/et_pb_text][et_pb_button button_url=”/checkouts/uepc-checkout/” button_text=”👉 ADD THE COMPLETE WEB AUTOMATION COURSE TO MY ORDER INSTANTLY!” button_alignment=”center” _builder_version=”4.12.1″ _module_preset=”default” custom_button=”on” button_text_color=”#FFFFFF” button_bg_color=”#e78d3e” button_use_icon=”off” background_layout=”dark” custom_padding=”20px|20px|20px|20px|true|true” global_colors_info=”{}” transform_styles__hover_enabled=”on|desktop” transform_scale__hover_enabled=”on|desktop” transform_translate__hover_enabled=”on|desktop” transform_rotate__hover_enabled=”on|desktop” transform_skew__hover_enabled=”on|desktop” transform_origin__hover_enabled=”on|desktop” transform_scale__hover=”108%|108%”][/et_pb_button][et_pb_text _builder_version=”4.4.7″ text_font=”Libre Baskerville||on||||||” text_text_color=”rgba(24,39,57,0.94)” text_line_height=”26px” text_orientation=”center” global_colors_info=”{}”]All courses come with a 30-day money back guarantee.

[/et_pb_text][et_pb_image src=”http://excelvbaisfun.com/wp-content/uploads/2020/06/paypal-verifieddan.png” title_text=”paypal-verifieddan” _builder_version=”4.12.1″ hover_enabled=”0″ global_colors_info=”{}” align=”center” sticky_enabled=”0″][/et_pb_image][/et_pb_column][et_pb_column type=”1_2″ _builder_version=”4.4.7″ global_colors_info=”{}”][et_pb_image src=”http://excelvbaisfun.com/wp-content/uploads/2020/06/30day-guarantee.png” title_text=”30day-guarantee” _builder_version=”4.4.7″ global_colors_info=”{}”][/et_pb_image][/et_pb_column][/et_pb_row][et_pb_row _builder_version=”4.12.1″ _module_preset=”default” width=”60%” max_width=”2560px” hover_enabled=”0″ global_colors_info=”{}” sticky_enabled=”0″ custom_padding=”||47px|||”][et_pb_column type=”4_4″ _builder_version=”4.11.4″ _module_preset=”default” global_colors_info=”{}”][et_pb_text _builder_version=”4.12.1″ _module_preset=”default” text_font=”||||on||||” text_font_size=”14px” text_line_height=”1.2em” text_orientation=”center” global_colors_info=”{}”]

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. 🙁

[/et_pb_text][/et_pb_column][/et_pb_row][/et_pb_section][et_pb_section fb_built=”1″ _builder_version=”4.12.0″ background_color=”#FFFFFF” background_color_gradient_direction=”319deg” background_enable_image=”off” custom_padding=”0px||0px|0px|true|false” locked=”off” global_colors_info=”{}”][et_pb_row custom_padding_last_edited=”on|tablet” _builder_version=”4.4.7″ width=”55%” width_tablet=”100%” width_phone=”” width_last_edited=”on|tablet” custom_padding=”||15px||false|false” custom_padding_tablet=”0px||0px||false|false” custom_padding_phone=”” module_alignment_tablet=”center” module_alignment_phone=”” module_alignment_last_edited=”on|tablet” global_colors_info=”{}”][et_pb_column type=”4_4″ _builder_version=”4.4.7″ global_colors_info=”{}”][et_pb_text _builder_version=”4.12.0″ header_text_color=”#FFFFFF” header_2_font=”Roboto|900|||||||” header_2_text_align=”center” header_2_text_color=”#000000″ header_2_font_size=”40px” header_2_line_height=”50px” text_orientation=”center” custom_margin=”26px|||||” custom_margin_tablet=”” custom_margin_phone=”0px||||false|false” custom_margin_last_edited=”on|phone” custom_padding=”||||false|false” custom_padding_tablet=”” custom_padding_phone=”15px|||0px|false|false” custom_padding_last_edited=”on|phone” header_2_text_align_tablet=”” header_2_text_align_phone=”center” header_2_text_align_last_edited=”on|phone” header_2_font_size_tablet=”” header_2_font_size_phone=”33px” header_2_font_size_last_edited=”on|phone” header_2_line_height_tablet=”” header_2_line_height_phone=”50.8px” header_2_line_height_last_edited=”on|phone” locked=”off” global_colors_info=”{}” custom_padding__hover_enabled=”off|desktop”]

Your Full Course Curriculum

[/et_pb_text][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=”22px” header_4_line_height=”28px” text_orientation=”center” global_colors_info=”{}”]

Complete Web Automation With Excel VBA

[/et_pb_text][/et_pb_column][/et_pb_row][et_pb_row custom_padding_last_edited=”on|tablet” _builder_version=”4.4.7″ width=”55%” width_tablet=”83%” width_phone=”93%” width_last_edited=”on|phone” custom_padding_tablet=”||0px||false|false” custom_padding_phone=”” locked=”off” global_colors_info=”{}”][et_pb_column type=”4_4″ _builder_version=”4.4.7″ global_colors_info=”{}”][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” 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” 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” 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” 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” 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” 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” 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” 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” 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” 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” 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” 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” 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″ module_id=”faq” _builder_version=”4.12.0″ _module_preset=”default” background_color=”#000000″ collapsed=”on” global_colors_info=”{}”][et_pb_row _builder_version=”4.9.4″ _module_preset=”default” global_colors_info=”{}”][et_pb_column type=”4_4″ _builder_version=”4.9.4″ _module_preset=”default” global_colors_info=”{}”][et_pb_text _builder_version=”4.9.11″ _module_preset=”default” text_font=”Oswald|600|||||||” text_text_color=”#FFFFFF” text_font_size=”60px” text_letter_spacing=”1px” text_line_height=”1.2em” text_orientation=”center” text_font_size_tablet=”” text_font_size_phone=”33px” text_font_size_last_edited=”on|desktop” global_colors_info=”{}”]Frequently Asked Questions
[/et_pb_text][et_pb_text _builder_version=”4.12.1″ _module_preset=”default” text_text_color=”#FFFFFF” text_font_size=”30px” text_line_height=”1.3em” global_colors_info=”{}”]

How Long Is the Course?

We currently have over 9.5 hours of progressive on-demand video that you can view anytime you want and from any device that can load a website..

I’m a beginner and I’ve never done programming, is this really for me?

YES! This Excel course is for anyone who wants to learn Automation secrets in Excel VBA for controlling websites. No prior programming knowledge is needed.

Do you have support for Excel for Mac?

Unfortulately, Apple computers don’t recognize EXE files or type libraries (.tlb) files, so they won’t be able to easily use the type library that Excel needs to run Selenium.

The Selenium type library is the thing that can connect your Excel file(s) to and communicate with and control all the different web browsers. We hope Macs will someday be able to use and play nice with Windows technology and vice versa, but it won’t currently work.

[/et_pb_text][et_pb_button button_url=”/checkouts/uepc-checkout/” button_text=”👉 ADD THE COMPLETE WEB AUTOMATION COURSE TO MY ORDER INSTANTLY!” button_alignment=”center” _builder_version=”4.12.1″ _module_preset=”default” custom_button=”on” button_text_color=”#FFFFFF” button_bg_color=”#e78d3e” button_use_icon=”off” background_layout=”dark” custom_padding=”20px|20px|20px|20px|true|true” global_colors_info=”{}” transform_styles__hover_enabled=”on|desktop” transform_scale__hover_enabled=”on|desktop” transform_translate__hover_enabled=”on|desktop” transform_rotate__hover_enabled=”on|desktop” transform_skew__hover_enabled=”on|desktop” transform_origin__hover_enabled=”on|desktop” transform_scale__hover=”108%|108%”][/et_pb_button][/et_pb_column][/et_pb_row][/et_pb_section][et_pb_section fb_built=”1″ _builder_version=”4.9.4″ _module_preset=”default” collapsed=”on” global_colors_info=”{}”][et_pb_row use_custom_gutter=”on” make_equal=”on” _builder_version=”4.9.4″ _module_preset=”default” width=”100%” max_width=”100%” module_alignment=”center” global_colors_info=”{}”][et_pb_column type=”4_4″ _builder_version=”4.9.4″ _module_preset=”default” custom_padding=”|0px||0px|false|true” global_colors_info=”{}”][et_pb_text _builder_version=”4.9.4″ _module_preset=”default” text_text_color=”rgba(28,28,28,0.93)” text_font_size=”22px” text_line_height=”1.3em” text_orientation=”center” global_colors_info=”{}”]© 2021 – Strong Software Solutions LLC | ExcelVbaIsFun – Privacy PolicyTerms and Conditions

This site is not a part of the Facebook website or Facebook Inc. Additionally, This site is NOT endorsed by Facebook in any way.

FACEBOOK is a trademark of FACEBOOK, Inc.
[/et_pb_text][/et_pb_column][/et_pb_row][/et_pb_section]

Excel VBA Is Fun

We believe Excel is one of the most versatile programs out there - and learning to program and automate it makes you very valuable!

You can prevent wasted time and errors, speed up tasks and become indispensable to your organization. 

See how our trainees have gotten raises, promotions and bonuses using their Excel Automation skills while building real problem-solving programs in Excel!
LEARN MORE
Copyright © 2022 ExcelVbaIsFun
X

Forgot Password?

Join Us

0
    0
    Your Cart
    Your cart is emptyReturn to Shop
    linkedin facebook pinterest youtube rss twitter instagram facebook-blank rss-blank linkedin-blank pinterest youtube twitter instagram