1 Attachment(s)
Get live changes of a number on a webpage
Dears,
I hope each and every one of you is having a good day
So what I'm trying to do is: There is a webpage that has some numbers that are continuously changing, I want a cell of my excel sheet to get live updates of one of the numbers on the webpage.
What I have so far: I wrote a VBA code (First time VBA, kind of expert in Java), that gets the number and sets it inside the active cell without any problem. But, what I want it to do is keep getting live updates of the number on the webpage.
What I tried to get live updates: I tried to use an infinite loop but it makes my Excel window unresponsive. I also tried Application.OnTime but I failed to find-out how to pass a parameter to it
Here's my excel file, you can see the VBA code: Attachment 27588
Any help is appreciated
Best regards