VBA script to scrape a single HTML element's value

Question

I've looked at about 30 different questions, and each one deals with "getelementbyID". My issue is the element I need to scrape doesn't have an id:

I see it is inside of an "h6" class or tag, but

    msgbox IEObj.Document.getelementsbytagname("h6").Value
    msgbox IEObj.Document.getelementsbyclassname("h6").Value

just returns the "Object doesn't support this property or method". What am I doing wrong?? (The rest of the code just sets up a IE Object called IEObj, and navigates to this page, so it's unimportant).

what might be more useful is if we can see more of the html. — Scott Holtzman
– Scott Holtzman, Commented Jun 3, 2016 at 20:18
getElementsbyClassName and getElementsByTagName gives you an array back. Basically it gives you all items back, as Class and tagName are not unique unlike ID's. You need to specify which item you want. Like: IeObj.Document.getElementsByTagName("h6")(0).InnerText — Ryan Wildry
– Ryan Wildry, Commented Jun 3, 2016 at 20:28

PaichengWu · Accepted Answer · 2016-06-04 22:53:51Z

1

you must find the h6 which the innertext is "Expected delivery". Then, get the innertext of h6.

dim webH6 as object, webTag as object, deliveryDate as variant
    for each webH6 in ie.document.getelementsbytagname("h6")
        if webH6.getelementsbytagname("a")(0).innertext = "Expected delivery" then
            deliveryDate = trim(replace(webH6.innertext, ":", ""))
            exit for
        end if
    next webH6

edited Jun 4, 2016 at 22:53

answered Jun 4, 2016 at 15:16

PaichengWu

2,6891 gold badge16 silver badges28 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

C-Love511 Over a year ago

Yes, this should work, but I get a "Object doesn't support this method" error on the second line. Seriously. That's why I came here in the first place, since every tutorial and help site I've seen gives the same advice and it gives the same error...

PaichengWu Over a year ago

i correct line 2 from ie.getelementsbytagname("h6") to ie.document.getelementsbytagname("h6").

PaichengWu Over a year ago

@C-Love511 If my answer can solve your problem, could you please accept my answer? I am new here, so I need reputation.

C-Love511 · Accepted Answer · 2016-06-04 20:57:41Z

0

Okay, the answer above me is correct.

Actually, all of the tutorials are.

I kept getting "Permission denied" errors (70) when I'd loop through the elements. Turns out that the website detects scripts and stops them from running for security reasons. Otherwise, the code should work perfectly!

answered Jun 4, 2016 at 20:57

C-Love511

3581 gold badge9 silver badges26 bronze badges

Collectives™ on Stack Overflow

VBA script to scrape a single HTML element's value

2 Answers 2

3 Comments

Comments

Your Answer

Collectives™ on Stack Overflow

VBA script to scrape a single HTML element's value

2 Answers 2

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related