Here's my excel file, you can see the VBA code: Book1.xlsm
Any help is appreciated
Best regards[/QUOTE]
Hi. If that's the data that you want, and that's the website that you want to get it from, then I'd recommend skipping VBA/IE altogether and just letting Excel handle it for you through a simple data query (Data Tab -> Get Data -> Get Data from Web). This will source the data for you and deposit it onto a spreadsheet as per the picture below. It also runs continuous updates of the data for you.
It's a lot quicker and more efficient than using VBA to resurrect additional instances of IE every two seconds to go find out the data for you!!
Separately, as regards your code, you were on the right track with your Application.Ontime approach, and with the parameters you were using, except for two points:
Application.OnTime Now + TimeValue("00:00:02"), "'RunEveryOneSecond " & IE & "'"
Here, you were trying to concatenate a string with an object (IE) and this was never going to work.
I wrote a much longer post setting out my comments, and attaching a screen capture, but the system rejected it and deleted all my text in the post. Having lost my sense of humour with this system, and needing to go to sleep, I'll have to leave it here, in hopes that one of the admins (benevolently) permits me to post this on the site. Let me know if you need any help with the above and I will try again tomorrow.