Downloading Data from Website via VBA Macro: No Element ID/Name, GetElements Solution

Question

Please help. I have to download data from the website, but unfortunately no element on the page has its own ID, name, etc. Therefore, the use of .getElementsById or .getElementsByTagName is probably out of the question (or at least I don't know how to connect it). Below I am attaching a...

rufek90 · Answer

I don't know much about VBA, but html elements can be downloaded e.g. by tag name or class. Here 'document api': https://developer.mozilla.org/en-US/docs/Web/API/Document
It is worth paying attention to the querySelector and querySelectorAll methods: https://developer.mozilla.org/pl/docs/Web/API/Document/querySelector which allows you to very precisely define what elements you are looking for. Thanks to this, perhaps we can do without some loops by elements

mistrzszymon1 · Answer

What is generating these tables ?? Can you paste this code instead of a photo? /

Montana310 · Answer

Generally, the code is generated by a program that gives us order data. Unfortunately, I do not have the code now, because I only made printscreen what the script of the page looks like. Maybe tomorrow I will be able to do it.

mistrzszymon1 · Answer

Most likely, the program can be set to add a class or an id :)

Added after 2 [minutes]:

If not, as rufek90 querySelector wrote, and matching what you need

A colleague forgot to mention what he wants to learn from this document

rufek90 · Answer

I recommend running the development console and testing the selectors there to find the right one. Some example: document.querySelector ('. DataWidget tr: nth-of-type (3) td: nth-of-type (2)');
Instead of nth-of-type, you can use querySelectorAll and select the appropriate items from the array. You need to familiarize yourself with the basics of using the console in the browser.

If you throw in all the sample html and say which fields you are interested in, I will try to help with the selection

kinggustav · Answer

You have to get each item by id, either bulk by class or tag type (good for tables). You will probably have to mix these methods to get where you need to go. It all depends on the construction of this website.
Look for "vba excel ie automation" in googles. There are a lot of materials, but specifically in your case it takes ... a lot of time. And you must have it or buy it, because time is money.

WRadek · Answer

And if you are truly desperate, you can download the entire source of the page as text and then work on the text. I was able to do everything I wanted to get out like that.

Downloading Data from Website via VBA Macro: No Element ID/Name, GetElements Solution

Post #1

Post #2

Post #3

Post #4

Post #5

Post #6

Post #7

Post #8

Didn't find an answer? Ask Artificial Intelligence

Topic summary