Run-time error 5 - occasional HTML problem

[killerkoz17]

Hi everyone,

I have a macro that runs through a column of URLs and extract the same data from each URL. The problem is that occasionally the macro errors with "Run-time error 5: Invalid procedure call or argument". It errors at the line: "RXLocation = InStr(URLLocation ..." When I manually visit the URL in IE it opens fine. Any ideas what is causing this problem?

Please Login or Register  to view this content.

Cheers, Rob

[Marc L]

Hi,

check variable value URLLocation ! If null, error occurs …

[killerkoz17]

Hi Marc,

Thanks for the reply. Yes, URLLocation = 0 when the error occurs. Most of the time it is good, sometimes bad

Cheers, Rob

[Marc L]

Check the value of READYSTATE_COMPLETE ?

Bad if equals to zero ! 'Cause IE variable is defined in late binding … (no problem in early binding)

So update with Loop Until IE.readyState = 4 …