Thread: ie Command to Wait for "File Download" and "Save As" windows
View Single Post
  #9   Report Post  
Posted to microsoft.public.excel.programming
JP[_4_] JP[_4_] is offline
external usenet poster
  
Posts: 897
Default ie Command to Wait for "File Download" and "Save As" windows
Sorry, at this point I'm just fishing.

How about changing

Do Until ie.ReadyState = READYSTATE_COMPLETE

to

Do While ie.ReadyState < READYSTATE_COMPLETE


Kindly allow me some time to test your code and see if I can offer any
further suggestions.


Thx,
JP

On Jan 8, 8:09*pm, wrote:
I just tried Steve's code *in place of my previous readystate commands
and unfortunately I get an error at Problems 2 and 3 at the line

Do While (ie.Busy)

Reply With QuoteReply With Quote