• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

avoid errors made by a scrapping

C

claudia80

Member
i have a Macro scrapping, and every time it's blocked with different error codes, I have to click on debug and then set myself on the next code line and click on f5 later to start it again.
Thanks


is there any way to automatically jump all sorts of mistakes by avoiding blocks and manual actions?


could you point me to a web page later, can I find the explanation?


thank you
 
If using On Error Resume Next you must check each result which can be an error …​
​
 
could you give some advice or could you please point out some web pages where the different cases are waved with the relevant instructions you could use?
 
The only advice is a per the logic in use to reach your need in the worst case the procedure has an On Error Resume Next codeline​
obviously you must check if each result matches what is expected …​
As any scrapping code working a day may not work the next day after a webpage code update,​
there is no generic code as it's specific to each webpage like you can see in many samples on Web …​
​
 
are there other types of instructions to avoid Macro blocks due to errors that make the menu open where it is possible to click on debug to detect the mistake, actually block Macro?
 
As any statement relative to web scrapping can raise an error without any obvious synchronisation and​
as - again - no generic code as it's specific to each webpage, see just operating, testing, training, web searching, …​
​
As VBA was very not designed for web scrapping you may better see how works Excel PowerQuery, samples on forums …​
​
 
You must log in or register to reply here.
Back
Top