Guru do Excel e Power BI

Hello guy! I want to copy some data to my excel, but I do not how to do that, can anyone help me?

I work for a sport company: https://www.livescore18.com/

And I need to copy some game data into Excel, Is there any convenient method to do that? I don't want to copy data one by one....Pls help me....

Hi, @ygrace680!

Did you tried to use document.GetElementById() or document.QuerySelector() with VBA?

• GetElementById() to catch values from DOM by the items IDs;

• QuerySelector() to catch values from DOM by items type like class, id, methods (i.e. <span>, <div>, <h1>, <p>, etc.);

You can inspect through pages codes by pressing right click and going in "Inspect Element", for example.
I've seen the page and is more easy using QuerySelector().. anyway.. it's an option! Try this if you want.

Good luck!
Huggies

Hi, ygrace680

In this site you can have several solutions on this subject.

https://chandoo.org/forum/

You can also try using the WEBSERVICE function.

Decio