intoxicated_curveball
asked on
Automation error using CreateObject("InternetExplorer.Application")
I'm using the following code in VBA:
Dim IE As Object
Set IE = CreateObject("InternetExpl orer.Appli cation")
I've also tried:
Dim IE As Object
Set IE = New InternetExplorerMedium
I always finish with:
IE.Quit
Set IE = Nothing
But I randomly get an "Automation Error" (usually is fine except for about 1 quarter of the time):
Run-time error '-2147023706 (8000704a6)':
Automation error
A system shutdown has already been scheduled.
Seems like IE is not closing properly sometimes.
Dim IE As Object
Set IE = CreateObject("InternetExpl
I've also tried:
Dim IE As Object
Set IE = New InternetExplorerMedium
I always finish with:
IE.Quit
Set IE = Nothing
But I randomly get an "Automation Error" (usually is fine except for about 1 quarter of the time):
Run-time error '-2147023706 (8000704a6)':
Automation error
A system shutdown has already been scheduled.
Seems like IE is not closing properly sometimes.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
silly question, but have you rebooted since getting the error?
ASKER
Rebooting or waiting a few minutes seems to always work. But I'm using this frequently so that's only a temp solution. Seems to have something to do with the object or process still running enough though it shouldn't be?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.