Complete Web Automation with Excel VBA

1. Complete Web Automation with Excel VBA/12. Selecting Options from Dropdowns and Listboxes/10. Exercise 12a - Answer.mp4176.94MB
2. Complete Web Automation with Excel VBA/1. Introduction - Getting Started & Setup/1. Introduction and Course Download Files.mp49.53MB
3. Complete Web Automation with Excel VBA/1. Introduction - Getting Started & Setup/2. Getting & Installing Selenium.mp49.22MB
4. Complete Web Automation with Excel VBA/2. Selenium Basics/1. Opening a Web Page.mp412.03MB
5. Complete Web Automation with Excel VBA/2. Selenium Basics/2. Web Elements 101 - Type in Textbox and Click Search Button (ID,Name Selectors).mp490.9MB
6. Complete Web Automation with Excel VBA/2. Selenium Basics/3. HTML Overview - Popular Tags and Attributes.mp417.84MB
7. Complete Web Automation with Excel VBA/2. Selenium Basics/4. Strategies - Tag.mp438.19MB
8. Complete Web Automation with Excel VBA/2. Selenium Basics/5. Awful-Valentine Site Expired, But We Downloaded It!.mp423.14MB
9. Complete Web Automation with Excel VBA/2. Selenium Basics/6. Strategies - Class.mp450.65MB
10. Complete Web Automation with Excel VBA/2. Selenium Basics/7. Exercise 02a - Question.mp43.52MB
11. Complete Web Automation with Excel VBA/2. Selenium Basics/8. Exercise 02a - Answer.mp447.36MB
12. Complete Web Automation with Excel VBA/2. Selenium Basics/9. Strategies - LinkText.mp415.51MB
13. Complete Web Automation with Excel VBA/2. Selenium Basics/10. Looking At Attributes - More Than Just TEXT!.mp432.52MB
14. Complete Web Automation with Excel VBA/2. Selenium Basics/11. Strategies - PartialLinkText.mp414.69MB
15. Complete Web Automation with Excel VBA/2. Selenium Basics/12. Strategies - CSS Selectors Intro.mp484.89MB
16. Complete Web Automation with Excel VBA/2. Selenium Basics/13. How to Install a Chrome Extension.mp49.59MB
17. Complete Web Automation with Excel VBA/2. Selenium Basics/14. CSS Selector Helper for Chrome.mp436.94MB
18. Complete Web Automation with Excel VBA/2. Selenium Basics/15. CSS Selector Tool - ChroPath and Technical Demonstration.mp4110.18MB
19. Complete Web Automation with Excel VBA/2. Selenium Basics/16. BONUS - Set Value versus SendKeys To TextBox.mp493.51MB
20. Complete Web Automation with Excel VBA/3. Advanced Find With XPath/1. Introduction to XPath.mp458.89MB
21. Complete Web Automation with Excel VBA/3. Advanced Find With XPath/2. XPath Helper Tool.mp450.21MB
22. Complete Web Automation with Excel VBA/3. Advanced Find With XPath/3. ChroPath with XPath for Relative and Absolute Reference Types.mp446.32MB
23. Complete Web Automation with Excel VBA/3. Advanced Find With XPath/4. XPath Function - Contains().mp445.29MB
24. Complete Web Automation with Excel VBA/3. Advanced Find With XPath/5. XPath Function - Text().mp416.74MB
25. Complete Web Automation with Excel VBA/3. Advanced Find With XPath/6. XPath Function - AND, OR.mp420.48MB
26. Complete Web Automation with Excel VBA/3. Advanced Find With XPath/7. XPath Function - Starts-With().mp49.13MB
27. Complete Web Automation with Excel VBA/3. Advanced Find With XPath/8. XPath - Axes.mp469.63MB
28. Complete Web Automation with Excel VBA/3. Advanced Find With XPath/9. XPath Function - Last().mp418.16MB
29. Complete Web Automation with Excel VBA/3. Advanced Find With XPath/10. Selecting a Specific Index for XPath Query!.mp425.23MB
30. Complete Web Automation with Excel VBA/3. Advanced Find With XPath/11. Exercise 03a - Question.mp43.05MB
31. Complete Web Automation with Excel VBA/3. Advanced Find With XPath/12. Exercise 03a - Answer.mp479.23MB
32. Complete Web Automation with Excel VBA/4. Working With Multiple Elements At Once/1. Working With a Group Of Elements (FindElements).mp437.77MB
33. Complete Web Automation with Excel VBA/4. Working With Multiple Elements At Once/2. Looping Through a Set of Elements, Declaration Tips.mp444.43MB
34. Complete Web Automation with Excel VBA/4. Working With Multiple Elements At Once/3. Grab the Text For Each Element Into A List.mp431.13MB
35. Complete Web Automation with Excel VBA/4. Working With Multiple Elements At Once/4. Grabbing All Attribute Values into a List.mp412.72MB
36. Complete Web Automation with Excel VBA/4. Working With Multiple Elements At Once/5. Add, Remove or Change an Element from a List.mp452.15MB
37. Complete Web Automation with Excel VBA/4. Working With Multiple Elements At Once/6. Get Count of List Items or Web Elements.mp415.02MB
38. Complete Web Automation with Excel VBA/4. Working With Multiple Elements At Once/7. Remove Duplicates Elements from List.mp413.05MB
39. Complete Web Automation with Excel VBA/4. Working With Multiple Elements At Once/8. Sorting Your List.mp414.64MB
40. Complete Web Automation with Excel VBA/4. Working With Multiple Elements At Once/9. Importing Items to Excel Directly!.mp424.35MB
41. Complete Web Automation with Excel VBA/4. Working With Multiple Elements At Once/10. Looping Through a List of Attributes for a Set of Elements.mp478.51MB
42. Complete Web Automation with Excel VBA/4. Working With Multiple Elements At Once/11. Exercise 04a - Question.mp43.54MB
43. Complete Web Automation with Excel VBA/4. Working With Multiple Elements At Once/12. Exercise 04a - Answer.mp451.46MB
44. Complete Web Automation with Excel VBA/4. Working With Multiple Elements At Once/13. Finding Elements within an Element.mp444.36MB
45. Complete Web Automation with Excel VBA/5. Element Properties, Methods and Useful Information/1. Find the Active Element.mp428.34MB
46. Complete Web Automation with Excel VBA/5. Element Properties, Methods and Useful Information/2. Understanding the 'By' Object.mp422.15MB
47. Complete Web Automation with Excel VBA/5. Element Properties, Methods and Useful Information/3. Does The Element Exist Using 'By' Object.mp421.39MB
48. Complete Web Automation with Excel VBA/5. Element Properties, Methods and Useful Information/4. Does Element Exist Using WebElement Object (2 Ways!).mp439.37MB
49. Complete Web Automation with Excel VBA/5. Element Properties, Methods and Useful Information/5. Value, Tagname, Text & Css Properties.mp452.3MB
50. Complete Web Automation with Excel VBA/5. Element Properties, Methods and Useful Information/6. Specialty Text Variations.mp417.85MB
51. Complete Web Automation with Excel VBA/5. Element Properties, Methods and Useful Information/7. Discover Whether Element is Displayed, Enabled, Present, Selected....mp457.59MB
52. Complete Web Automation with Excel VBA/5. Element Properties, Methods and Useful Information/8. Pagination - Clicking Next Until You Reach the Last Page.mp467.78MB
53. Complete Web Automation with Excel VBA/5. Element Properties, Methods and Useful Information/9. Element Position and Size.mp424.45MB
54. Complete Web Automation with Excel VBA/5. Element Properties, Methods and Useful Information/10. Scrolling Element Into View.mp430.08MB
55. Complete Web Automation with Excel VBA/5. Element Properties, Methods and Useful Information/11. Regular Expression Patterns!.mp4120.2MB
56. Complete Web Automation with Excel VBA/5. Element Properties, Methods and Useful Information/12. Return Text Based on Regular Expression (RegEx).mp445.91MB
57. Complete Web Automation with Excel VBA/5. Element Properties, Methods and Useful Information/13. Automatically Download File to Custom Folders with SetPreference().mp475.38MB
58. Complete Web Automation with Excel VBA/6. Built In Comparison Operators/1. Assert vs Verify.mp418.04MB
59. Complete Web Automation with Excel VBA/6. Built In Comparison Operators/2. Equals Comparison Operator.mp437.2MB
60. Complete Web Automation with Excel VBA/6. Built In Comparison Operators/3. Not Equals.mp47.53MB
61. Complete Web Automation with Excel VBA/6. Built In Comparison Operators/4. Contains.mp414.88MB
62. Complete Web Automation with Excel VBA/6. Built In Comparison Operators/5. Custom Error Messages.mp413.98MB
63. Complete Web Automation with Excel VBA/6. Built In Comparison Operators/6. Matches & NotMatches.mp430.68MB
64. Complete Web Automation with Excel VBA/6. Built In Comparison Operators/7. Fail, False and True.mp422.61MB
65. Complete Web Automation with Excel VBA/7. Mouse and Keyboard Actions/1. Click, Click and Hold, Release, Right Click & Double Click.mp488.96MB
66. Complete Web Automation with Excel VBA/7. Mouse and Keyboard Actions/2. SendKeys and Keys Modifiers.mp459.76MB
67. Complete Web Automation with Excel VBA/7. Mouse and Keyboard Actions/3. KeyDown, KeyUp.mp423.27MB
68. Complete Web Automation with Excel VBA/7. Mouse and Keyboard Actions/4. Exercise 07a - Question.mp43.55MB
69. Complete Web Automation with Excel VBA/7. Mouse and Keyboard Actions/5. Exercise 07a - Answer.mp442.12MB
70. Complete Web Automation with Excel VBA/7. Mouse and Keyboard Actions/6. DragAndDrop - Swapping Elements, Better with JavaScript.mp449.36MB
71. Complete Web Automation with Excel VBA/7. Mouse and Keyboard Actions/7. DragAndDrop - Element Disappears Once Dropped.mp419.37MB
72. Complete Web Automation with Excel VBA/7. Mouse and Keyboard Actions/8. DragAndDrop - Dragging Text Programmatically.mp415.75MB
73. Complete Web Automation with Excel VBA/7. Mouse and Keyboard Actions/9. DragAndDrop - Dragging File for Upload Programmatically.mp425.71MB
74. Complete Web Automation with Excel VBA/7. Mouse and Keyboard Actions/10. Hover MenuItem and Click On Submenu Item.mp458.7MB
75. Complete Web Automation with Excel VBA/7. Mouse and Keyboard Actions/11. Clear Out Text Entry Element.mp49.5MB
76. Complete Web Automation with Excel VBA/8. Timeouts and Waits/1. TimeOuts and Wait DEFAULTS.mp427.03MB
77. Complete Web Automation with Excel VBA/8. Timeouts and Waits/2. Basic Wait Command.mp421.05MB
78. Complete Web Automation with Excel VBA/8. Timeouts and Waits/3. Exercise 08a - Question.mp43.04MB
79. Complete Web Automation with Excel VBA/8. Timeouts and Waits/4. Exercise 08a - Answer.mp431.95MB
80. Complete Web Automation with Excel VBA/8. Timeouts and Waits/5. Finding Elements With a Custom TimeOut Duration.mp439.07MB
81. Complete Web Automation with Excel VBA/8. Timeouts and Waits/6. Wait Until Element is Displayed.mp421.8MB
82. Complete Web Automation with Excel VBA/8. Timeouts and Waits/7. Wait For Specific Text or a Specific Attribute to Appear!.mp497.43MB
83. Complete Web Automation with Excel VBA/8. Timeouts and Waits/8. Wait For CSS Special Value to Appear or Change.mp471.26MB
84. Complete Web Automation with Excel VBA/8. Timeouts and Waits/9. Wait for Text To Appear or Change.mp454.18MB
85. Complete Web Automation with Excel VBA/8. Timeouts and Waits/10. WaitNotElement and By.Any.mp442.12MB
86. Complete Web Automation with Excel VBA/8. Timeouts and Waits/11. WaitEnabled or Wait Until Element is Displayed.mp449.61MB
87. Complete Web Automation with Excel VBA/8. Timeouts and Waits/12. Wait For Selection With Checkboxes and OptionButtons.mp423.47MB
88. Complete Web Automation with Excel VBA/9. Browser Window Control, Navigation and Focus/1. Alerts - Using Multi Options (OK and Cancel, OK Only & Text) with An Alert.mp477.35MB
89. Complete Web Automation with Excel VBA/9. Browser Window Control, Navigation and Focus/2. SetCredentials Troubleshooting Tips and Authorization Dialog Popups.mp457.36MB
90. Complete Web Automation with Excel VBA/9. Browser Window Control, Navigation and Focus/3. Custom Function Testing Whether Dialog Popup Is Present.mp462.61MB
91. Complete Web Automation with Excel VBA/9. Browser Window Control, Navigation and Focus/4. Basic Navigation - Back, Forward, Reload, Close Driver, Close Single page, Url.mp461.8MB
92. Complete Web Automation with Excel VBA/9. Browser Window Control, Navigation and Focus/5. Setting A Custom Profile For WebDriver Session.mp471.95MB
93. Complete Web Automation with Excel VBA/9. Browser Window Control, Navigation and Focus/6. Add Special Arguments to Customize Browser Options - Incognito or Hidden Window.mp457.49MB
94. Complete Web Automation with Excel VBA/9. Browser Window Control, Navigation and Focus/8. Grab Html Page Source and Text From Parent Elements.mp447.94MB
95. Complete Web Automation with Excel VBA/9. Browser Window Control, Navigation and Focus/9. Exercise 09a - Question.mp43.54MB
96. Complete Web Automation with Excel VBA/9. Browser Window Control, Navigation and Focus/10. Exercise 09a - Answer.mp461.98MB
97. Complete Web Automation with Excel VBA/9. Browser Window Control, Navigation and Focus/11. Keep a Permanent WebDriver that Doesn't Close On Its Own.mp461.94MB
98. Complete Web Automation with Excel VBA/9. Browser Window Control, Navigation and Focus/12. Frames and Frame Nagivation.mp473.35MB
99. Complete Web Automation with Excel VBA/9. Browser Window Control, Navigation and Focus/13. Window, Tab Manipulation by Title, Index, Previous and Next.mp466.12MB
100. Complete Web Automation with Excel VBA/9. Browser Window Control, Navigation and Focus/14. Accessing Window By Name, Handle.mp421.88MB
101. Complete Web Automation with Excel VBA/9. Browser Window Control, Navigation and Focus/15. Close All Tabs Except Main Tab.mp447.56MB
102. Complete Web Automation with Excel VBA/9. Browser Window Control, Navigation and Focus/16. Several Ways To Open a New Tab In Current Session.mp429.06MB
103. Complete Web Automation with Excel VBA/9. Browser Window Control, Navigation and Focus/17. Window Sizing and Position.mp430.75MB
104. Complete Web Automation with Excel VBA/10. Image and Clipboard Manipulation/1. Save a Screenshot of Your Browser, Dispose Image in System Memory.mp446.79MB
105. Complete Web Automation with Excel VBA/10. Image and Clipboard Manipulation/2. Save Web Element as Image.mp439.58MB
106. Complete Web Automation with Excel VBA/10. Image and Clipboard Manipulation/3. Save Entire Desktop Screen as Image.mp420.83MB
107. Complete Web Automation with Excel VBA/10. Image and Clipboard Manipulation/4. Copy Image Directly to Excel OR To Clipboard.mp434.06MB
108. Complete Web Automation with Excel VBA/10. Image and Clipboard Manipulation/5. Image Dimensions and Resizing.mp446.35MB
109. Complete Web Automation with Excel VBA/10. Image and Clipboard Manipulation/6. Compare Two Images with CompareTo and DiffCount.mp446.6MB
110. Complete Web Automation with Excel VBA/10. Image and Clipboard Manipulation/7. Put Web Image Into Worksheet ActiveX Image Control.mp447.83MB
111. Complete Web Automation with Excel VBA/10. Image and Clipboard Manipulation/8. Load Image Into Userform Image.mp440.04MB
112. Complete Web Automation with Excel VBA/11. Working With Tables/1. Converting a Web Table to TableElement Object and Inserting into Worksheet.mp444.56MB
113. Complete Web Automation with Excel VBA/11. Working With Tables/2. Manipulating TableElement Data as Array onto Worksheet.mp4102.09MB
114. Complete Web Automation with Excel VBA/11. Working With Tables/3. Loop Through Elements in Specific Column Only.mp437.36MB
115. Complete Web Automation with Excel VBA/11. Working With Tables/4. Loop Through Multiple Specific Columns Using OR Operator.mp49.71MB
116. Complete Web Automation with Excel VBA/11. Working With Tables/5. Put Specific Columns into List Object, To Excel Easily.mp424.26MB
117. Complete Web Automation with Excel VBA/11. Working With Tables/6. Exercise 11a - Question.mp43.54MB
118. Complete Web Automation with Excel VBA/11. Working With Tables/7. Exercise 11a - Answer.mp4111.46MB
119. Complete Web Automation with Excel VBA/12. Selecting Options from Dropdowns and Listboxes/1. Declare SelectElement, Read and Write Dropdown Control.mp445.48MB
120. Complete Web Automation with Excel VBA/12. Selecting Options from Dropdowns and Listboxes/2. Select Using the Index Number.mp410.35MB
121. Complete Web Automation with Excel VBA/12. Selecting Options from Dropdowns and Listboxes/3. Select Using Internal Option Value.mp420.88MB
122. Complete Web Automation with Excel VBA/12. Selecting Options from Dropdowns and Listboxes/4. All About The Options Collection.mp432.95MB
123. Complete Web Automation with Excel VBA/12. Selecting Options from Dropdowns and Listboxes/5. Controlling Multiple Select ListBoxes and Gathering Selected Options.mp453.42MB
124. Complete Web Automation with Excel VBA/12. Selecting Options from Dropdowns and Listboxes/6. Using The Mouse To Select Multiple Options.mp436.47MB
125. Complete Web Automation with Excel VBA/12. Selecting Options from Dropdowns and Listboxes/7. Deselecting All Options or Specific Options.mp427.48MB
126. Complete Web Automation with Excel VBA/12. Selecting Options from Dropdowns and Listboxes/9. Exercise 12a - Question.mp43.06MB
127. Complete Web Automation with Excel VBA/13. BONUS - Extra Troubleshooting Tips/1. Error Loading Extension Help.mp448.78MB