Thread: Run time error when accessing Internet using VBA
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
musicgold via OfficeKB.com musicgold via OfficeKB.com is offline
external usenet poster
  
Posts: 7
Default Run time error when accessing Internet using VBA
Joel,

Thanks. I used the following code in my macro but still got the same error.
Now the error occurs at the combined condition statement.

Code:
  Do While .readyState < 4 Or .Busy = True: DoEvents: Loop

  Do While .Busy: DoEvents: Loop
  Do While .readyState < 4: DoEvents: Loop
--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200907/1

Reply With QuoteReply With Quote