View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Tim Coddington Tim Coddington is offline
external usenet poster
 
Posts: 94
Default Internet explorer object questions

Is it better to go ...
Dim ie As InternetExplorer
Set ie = New InternetExplorer
or
Dim ie As Object
Set ie = CreateObject("InternetExplorer.Application")

I had been using the former, but now I see examples in texts of the latter.
Here is another ...

It it better to go ...
Do
Loop Until ie.ReadyState = READYSTATE_COMPLETE
or
Do While ie.Busy
Loop

And is a 'DoEvents' useful in the Do loop?

Does ie.Silent keep the 'You are now exiting a secure web page' box from
popping up?

Thanks very much for your input!