View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
Jake Marx[_3_] Jake Marx[_3_] is offline
external usenet poster
 
Posts: 860
Default Using Excel VBA to close IE

JakeyC,

JakeyC wrote:
Also just dicvovered the Browser Control - I guess I could also use
this and then close (i.e. unload) the form in which it appears?


You could automate IE as well:

Sub Demo()
Dim ie As Object

Set ie = CreateObject("InternetExplorer.Application")

ie.navigate "http://www.longhead.com/"
Do While ie.busy And Not ie.readystate = 4
DoEvents
Loop

ie.Visible = True
Application.Wait Now + TimeSerial(0, 0, 5)
ie.Quit

Set ie = Nothing
End Sub

--
Regards,

Jake Marx
www.longhead.com


[please keep replies in the newsgroup - email address unmonitored]