Home
Creators
Search Recent Random
Posts
Search DMs Popular Hash Lookup Tags Random
Importer
Import FAQ
Register Favorites Keys Review DMs Logout
Community
Telegram ThePornDude
Home Creators Posts Import Register Favorites Logout

Web Scraping With Selenium Update [Gold & Silver] (Patreon)

Published:
2024-04-08 12:15:00
Imported:
2026-09

Downloads

Content

In this week’s Feature, Fix, or Focus, we take last week’s Web Scraping With Selenium training.

Here's the list of updates I made for this training:

· Add Selected Date w/ Date Picker added by Randy Austin

· Filter By Imact Type added by Randy Austin

· Add Entire Weeks Data added by Randy Austin

Please don’t forget to add your requests for your own Feature, Fix or Focus each week when I post a new video, right here on Patreon. Each week I will either add a new feature, fix a bug or an issue, or create another training with a special focus on any part, all based on your feedback and comments.

Files

Comments

Malcolm Sokol

Hi Randy.. Just downloaded the Selenium Updates on Patreon and tried the calendar feature that runs with Add Entred Date button and get a chrome driver version error. My chrome browser is up to date and I have no way to add a picture to this thread. The error occurs with Chrm.start or something similar in the Get Economic Events routine linked to the button. It says only works with driver version 107. But the message also says my chrome driver is 107.0.5304.62 so I would expect consistent version. Chrome browser itself is version 123..

Malcolm Sokol

Another question. I am usually pretty good at tracing code but I cannot find where in the Calendar Popup code you place the date from a selected cell into the cell that called the popup. In this application the selDate in AI2 triggers the popup but can't find how it gets refreshed. Checked old tutorials but while you show how the calendar is built, I didn't see code explained on retrieval of dates.

Malcolm Sokol

Maybe I found it. Syntax fooled me. There was an onaction assignment for !SelectDay which I was reading as ISelectDay and not the exclamation point. Never saw the use of the ! in that way. How do you use that to reference a macro name? The code makes sence but I was looking for a sub name that had a leading I not just the following code.

Excel For Freelancers

HI Malcom, Each day is assigned the same macro called SelectDay. We are able to differentiate which button was clicked by extracting the name of shape that called the macro using Application.caller, such as 12day for the 12th button Then we must get the day Number so we use the replace statement to remove the "Day" part of it leaving us the #. We then use this Number to determine the row and column # to extract the data from the pop-up calendar sheet. I hope this helps and thanks so much.

Malcolm Sokol

As I noted, it was mis-interpreted syntax with the ! infront of the sub name in the onaction assignment statement. With my vision not being 20-20 it looked like an I and could not find a routine with a leading I. This is unual syntax but I guess it happens with names list for some reason and usually used in worksheet formulas and very rarely in VBA as I have not noticed it previously being used in this manner. Maybe a topic for future video which may focus on odd-ball vba syntax statements when they occur.