VBA Excel Internet Explorer Web Scrapper Skipping Code

[M Acc]

I have an unusual question. I am currently using VBA to web scrape Internet Explorer. For various reasons, I can not give out the code but here is the gist, when I (and my coworker who is working independently) try to execute code, we have noticed that the compiler tends to skip lines of code (as in does not execute). So if I am trying to navigate through a webpage and I put something into the search bar, press enter, navigate to the resulting webpage and then go back, the program may only go back obviously causing problems. Has anyone else had this issue? Does anyone know what the problem is? Thanks, M

 

[Norie]

Are you sure code is being skipped?

There's every possibility, especially when automating IE, that code may appear to be being skipped.

 

[M Acc]

I am absolutely certain. In some cases, the Msgbox(Some Comment) code is being skipped. Its actual code, sometimes not even dealing directly with the IE navigation.

 

[M Acc]

To elaborate further, Sleep functions are being skipped, objIEApp GoBack functions are being skipped, lines in For Each for web scrapping each element are being skipped. This is not just happening with me. My coworkers are having very much the same issues so its not my particular code or computer. I don't know the root cause of this or why the compiler is choosing to skip. This has never happened to me before in VBA and I've been doing it for years now. Only since I've been grabbing IE instances to do web scraping. Has anyone else ever run into this issue?

 

[jackeroo75]

To elaborate further, Sleep functions are being skipped, objIEApp GoBack functions are being skipped, lines in For Each for web scrapping each element are being skipped. This is not just happening with me. My coworkers are having very much the same issues so its not my particular code or computer. I don't know the root cause of this or why the compiler is choosing to skip. This has never happened to me before in VBA and I've been doing it for years now. Only since I've been grabbing IE instances to do web scraping. Has anyone else ever run into this issue?

Is the data you are getting from the website created by javascript and can the data change dynamically within the IE?