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!
-
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!- yannickb
- Post #6
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Excel crashes when calling Doc Readystate
Hi, does anyone now the answer to my question?- yannickb
- Post #3
- Forum: VBA Visual Basic for Applications (Microsoft)
-
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.- yannickb
- Post #2
- Forum: VBA Visual Basic for Applications (Microsoft)
-
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...- yannickb
- Thread
- Replies: 5
- Forum: VBA Visual Basic for Applications (Microsoft)
