Closing internet explorer in an excel macro

[ag]

I am calling IE from an excel application (...hyperlink.follow)

Is there a way to automatically close that occurence of IE once the page
I called is displayed?
Or after a small amount of time?

thanks

AG

[Ron de Bruin]

Try this

It close IE after 3 seconds

Sub LoadWebPage1()
Dim oleIE As Object
Set oleIE = CreateObject("InternetExplorer.Application")
With oleIE
'.TheaterMode = True 'dit is volledig scherm
.Visible = True
.Navigate "http://www.rondebruin.nl/Google.htm"
Application.Wait (Now + TimeValue("0:00:03"))
.Quit
End With
End Sub
--
Regards Ron de Bruin
http://www.rondebruin.nl

Post by ag
I am calling IE from an excel application (...hyperlink.follow)
Is there a way to automatically close that occurence of IE once the page
I called is displayed?
Or after a small amount of time?
thanks
AG

[ag]

it works
thank you
AG

Post by Ron de Bruin
Try this
It close IE after 3 seconds
Sub LoadWebPage1()
Dim oleIE As Object
Set oleIE = CreateObject("InternetExplorer.Application")
With oleIE
'.TheaterMode = True 'dit is volledig scherm
.Visible = True
.Navigate "http://www.rondebruin.nl/Google.htm"
Application.Wait (Now + TimeValue("0:00:03"))
.Quit
End With
End Sub
--
Regards Ron de Bruin
http://www.rondebruin.nl

Post by ag
I am calling IE from an excel application (...hyperlink.follow)
Is there a way to automatically close that occurence of IE once the page
I called is displayed?
Or after a small amount of time?
thanks
AG