UdemyCourseDownloader Complete Web Automation with Excel VBA

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