Error in extracting web html page

[karmapala]

Hi,

I found a code in this link and try to run it from Excel.

Please Login or Register  to view this content.

It gives me an error #438 "Object doesn't support this property or method" at the red line.

Because in that link the code is the accepted answer, I wonder what did I do wrong ?
Do I need to do something else maybe ?

Any kind of help would be greatly appreciated.
Thank you in advanced.

(Attached is the inspector result from IE if maybe can help).

[efvba]

getElementsByClassName

[karmapala]

Hi efvba,

It still gives me an error after I change the "getElementByClassName" to "getElementsByClassName" on the same red code.
But the error now is error 91 : object variable or With block variable not set.
(I've also tried changing the "gelElementByTagName" to "getElementsByTagName", but still the same error 91)

Attached is the Tool References in my VBA editor.

Thank you.

[karmapala]

Please Login or Register  to view this content.

I'm playing around with the codes by single quote some original line (the green one),
and make some new lines (the blue one)... and now it works. My active sheet (cell A1 and B1) now fill with the rating.

I wonder why it isn't working with the green line.

Thank you.

[efvba]

No errors. Maybe you try my corrected code again.

Please Login or Register  to view this content.

[karmapala]

I've copied your code then paste it then run it.
I am very sorry, it is still the same error 91 at the red line, efvba.

My IE is ver 11.0 if it's maybe the problem ?

[efvba]

Not IE problem. My IE is also 11.

I think 3 pages are loaded in your first posted VBA, so the first HTML object is no longer applicable.

But it is ok for me, I don't understand.

[karmapala]

I still wonder, why if I change your code at the line

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

Then the code runs well, no error

Anyway, thank you once again for your help, efvba.
I really appreciate it.