Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by yannickb

  1. yannickb

    Excel crashes when calling Doc Readystate

    Hi everyone, Sorry for my late answer, i've been practising a lot with my script and i finally found out that Excel already crashes at the: Set doc = d.createDocumentFromUrl(url, vbNullString) part instead of the Doc.readystate, is there an alternative for this function? Thanks a lot!
  2. yannickb

    Excel crashes when calling Doc Readystate

    Hi, does anyone now the answer to my question?
  3. yannickb

    Excel crashes when calling Doc Readystate

    This is the doc-object: Dim d As New MSHTML.HTMLDocument Dim doc As HTMLDocument Set doc = d.createDocumentFromUrl(urlhun, vbNullString) After the 'Set doc' part the readystate check is being performed.
  4. yannickb

    Excel crashes when calling Doc Readystate

    Hi Everyone, I Made a VBA Macro for Excel, the VBA script checks several websites for links, source code etc. I get the links out of the source code by doc.Links Before the source-code is being downloaded I'm checking if the site is completely loaded. I perform this check by the following...

Part and Inventory Search

Back
Top