1. Welcome to Chandoo.org Forums. Short message for you

    Hi Guest,

    Thanks for joining Chandoo.org forums. We are here to make you awesome in Excel. Before you post your first question, please read this short introduction guide. When posting or responding to questions please remember our values at Chandoo.org are: Humility, Passion, Fun, Awesomeness, Simplicity, Sharing Remember that we have people here for whom English is not there first language and we need to allow for this in our dealings.

    Yours,
    Chandoo
  2. 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...

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

Scrapping - blocking by internet explorer

Discussion in 'VBA Macros' started by stefanoste78, Jul 8, 2017.

  1. stefanoste78

    stefanoste78 Member

    Messages:
    67
    good morning. I have a macro to extrapolate data from google. Recently when I used it after a few moments I appeared to have an empty white page. I updated the page and below I appeared this message:
    This is the translation: Internet Explorer has edited this page to prevent potential script attacks from other sites.
    Would you know why and how to prevent blocking by internet explorer?
    thank you
    ThrottleWorks likes this.
  2. Marc L

    Marc L Excel Ninja

    Messages:
    3,050

    Hi !

    As number of transactions is very limited within Google, better is to not use it !
    Or wait until next day to retry another request on Google …
    ThrottleWorks likes this.
  3. stefanoste78

    stefanoste78 Member

    Messages:
    67

    Google is the only complete search engine, what else can you use?
    However it is a problem of internet explorer not of google. I've seen it on the internet and recommend lowering the security level and activating external scripts. But not the same, maybe I'm wrong in something.
    I have a certainty that until the last week the macro was fine.
    ThrottleWorks likes this.
  4. Chihiro

    Chihiro Well-Known Member

    Messages:
    3,318
    Well, without your code it's hard for us to help you.

    If you are piloting IE, then you should not get hit by Google API's limit on transaction. This happens mostly when you use XMLHTTP to send requests directly to Google server(s).

    Try turning off XSS filter in IE (Google search for it and you should find it pretty quickly).
    ThrottleWorks likes this.
  5. stefanoste78

    stefanoste78 Member

    Messages:
    67
    I tried disabling the filter but it did not go .. :(
    Always comes the same message ..
    ThrottleWorks likes this.
  6. Chihiro

    Chihiro Well-Known Member

    Messages:
    3,318
    Without your code, and other details we can only guess at the cause.
    ThrottleWorks likes this.
  7. Marc L

    Marc L Excel Ninja

    Messages:
    3,050
    Nope ! And not so accurate …
  8. stefanoste78

    stefanoste78 Member

    Messages:
    67
    What would be a precise search engine from which I could extract business contacts?
  9. Chihiro

    Chihiro Well-Known Member

    Messages:
    3,318
    As far as I'm aware, there isn't "precise" search engine that can be used to extract business contacts consistently.

    What you may be looking for is business specific directory. They often have web interface, you can leverage to get info from. What directory/site you need to scrape will depend on your specific interest.
  10. stefanoste78

    stefanoste78 Member

    Messages:
    67
    Would mean to know in every state a precise website. Google is a generic site that can be used for any state even though there will be fewer contacts but does not imply the need to create a macro for each state.
  11. Chihiro

    Chihiro Well-Known Member

    Messages:
    3,318
    Do what you wish then.
  12. stefanoste78

    stefanoste78 Member

    Messages:
    67

    The important thing is to do it .. :)

Share This Page