Closing internet explorer in an excel macro
 

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

Closing internet explorer in an excel macro
 

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



"ag" wrote in message ...
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

Closing internet explorer in an excel macro
 

it works
thank you
AG

"Ron de Bruin" a écrit dans le message de news:
...
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



"ag" wrote in message
...
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