Posts by S O

I think it's crazy that ChatGPT is actually still only in testing and it's producing results like this. With the amount of attention it's gathered and the amount of test data it's consuming at the moment it's exciting (and slightly scary!) to see where the technology will lead.

It's a very close hit, but I suspect you'll see a minor tweak that needs to happen Very interesting to see these results though!

Hi troy79 - please can you also add link(s) to the other sites where you have posted this question. This is in line with the forum rules that you agreed to when you signed up.

Many thanks,

S O

Hi, welcome to OzGrid!

It would help if you could provide a worksheet that has an example of the data you are using, this helps to see the problem and create a better solution.

Kind regards,

S O

This is great Krishnakumar ! Top effort

jryan15 Please note that aside from these types of questions being against the forum rules - providing others with access and scraping the site is explicitly against the site's Terms of Use and could potentially cost you your membership.

Barchart do however have an API - so I would suggest looking into that instead of using scraping.

Please can you update your original post with the links to other sites where you have asked this question - or post the links here and a member of the team will update your post for you. Many thanks, Sam.

royUK for some reason your link doesn't seem to be working, I assume this is the page you were referring to: https://excel-it.com/store-datepickers.htm

PMRetired2012 for what it's worth I have used Roy's DatePicker on multiple projects and can fully endorse it

Hi PMRetired2012, welcome to OzGrid. Hope you're keeping safe and. well.

Please familiarise yourself with the rules (found in my signature) regarding cross posting and code tags. I've done it for you on this occasion but please be mindful for the future.

Cheers,

Sam

Hola elpicantemartinez, bienvenida a OzGrid.

¿Tu código está en español?

yo no sabo que podías hacer eso en VBA.

(lo siento, mi Español es muy malo )

Hi Serhito,

Welcome to OzGrid.

It looks like you're actually trying to get the list and then go two levels below it in the DOM? You can't use getElementsById because it doesn't have an ID.

I'd just get the dropdown directly rather than trying to go through child objects in the DOM:

Set List = ieObj.document.getElementsByClassName("earnings_announcements_earnings_table_length")(0)

Hi badabing, welcome to OzGrid.

Unfortunately what your asking is against LinkedIn terms of service:

Quote from LinkedIn ToS

• Except as expressly authorized by LinkedIn in writing, use any automated means or form of scraping or data extraction to access, modify, download, query or otherwise collect information from LinkedIn’s websites;

I will therefore close this thread with a quick reminder to please read any website's ToS before you attempt to do anything like this in future.

Best regards,

S O

That particular form was disabled deliberately due to some targeted spam attacks, I'll raise the broken links with the owner though - thanks for bringing it to our attention!

Quote from VWRSue

Hello,

I went to your Freebies section to see about basic Excel training for a co-worker. However, I am getting an error message when I click the link that either the link is broken or the page no longer exists, or has been moved. I then went to Contact and filled out the form to see if this training is still available, filled out the form, but I see no way to submit my question (no submit button, enter just enters to the next line, etc.).

Is the training still available?

How do we submit any Contact communication?

Display More

Hi VWRSue, please can you provide a link to the page you're trying to access and I can give you some further information. Feel free to DM me if easier.

Many thanks,

Sam

Payment received - many thanks!

I'll take this on anyway -will PM you the solution shortly

Hi - what currency are you paying in?

Awesome - yes please feel free to PM me