Error with Internet explorer while interaction

[YasserKhalil]

Hello everyone
I am trying to learn how to scrape data and I found a tutorial with this code

Please Login or Register  to view this content.

I got error at this line (error 91)

Please Login or Register  to view this content.

I appreciate any help

[Marc L]

Hi !

Bad code …

Check variable obj !

[YasserKhalil]

Thanks for reply
If I knew what is bad, I would fix it. I am just take it from a tutorial and I encountered an error and need to know what is the reason of this error and how to fix it

[Marc L]

Please share tutorial link, I want to take a glance to see if it is good or not …

Did you use a webbrowser inner inspector tool ? If yes from which webbrowser ?

[YasserKhalil]

This is the link
http://analystcave.com/web-scraping-tutorial/
As for your question, I have no idea about that? Do you mean View Source in web browsers?

[Marc L]

Several problems within your code !

• So this link is not so good for the Do Loop codelines !
Busy is not enough, you must wait also for IE ReadyState property until set to 4
as you can read on MSDN site (see official documentation), instead of using Wait …
See also code samples on this forum threads as well from other forums.

• How do you find elements id or name ? Using which webbrowser ?

[YasserKhalil]

I have updated IE and the first part is ok ... Now I have a problem with Search button which name is "btnK"
Here's a working code except for the part of the search button

Please Login or Register  to view this content.

[AB33]

There is no click button, but a submit form.
While IE.readyState <> 4: DoEvents: Wend

IE.Document.forms(0).submit

[YasserKhalil]

You got it Mr. AB33
Thanks a lot for this wonderful solution. I have searched a lot and all what I reached is workaround to use SendKeys to use "Enter" key
Thank you very much for great help

[Marc L]

You can also submit the button, works on my side too …

But you do not understand how IE works ! As IE.Busy is only for the initial load of the webpage, not after a mod like a button click …
And you will see that when you really try to pilot another webpage !

[YasserKhalil]

Thanks Mr. MarcL for reply and for providing us with more information.. I have learned a lot from you.
Regards