How to force close iexplore.exe ?

[thiskeep]

Hello all,
I always manual click [ESC] to stop at Running excel VBA for my macro test as IE.Navigate URL loop [visible=false] .

so the screen box will be shown :

Run-time error '91':
Object variable or With block variable not set


However, iexplore.exe hanging, will not closed, I need manual to close it on every time.
Actually, IE.Quit is no problem. my Set IE = New InternetExplorer [ IE7 XP ]

on the other hand, I try to use InternetExplorerMedium but not work defined what object.

Anyone have an idea and method can force to close iexplore.exe ?

[Norie]

Why don't you allow the code to run to the end instead of stopping it?

Can you post the code?

[Leith Ross]

Hello thiskeep,

You can force IE to close using the SendMessage API. Internet Explorer made the window handle available in IE 7. This is needed because all system messages are sent to windows using their window handle.
Place the API code at the top of a standard VBA module.

Excel 2003 API Call

Please Login or Register  to view this content.

Windows 7 and later API Call

Please Login or Register  to view this content.

Closing Internet Explorer Example

Please Login or Register  to view this content.

[thiskeep]

Why don't you allow the code to run to the end instead of stopping it?

Can you post the code?

Hi Norie
Nice to meet you.
I know that should be run to the end i/o stop,
but I need to run loop processing to improve my command,
coz IE cannot release memory [even I using eMoWeb Browser Optimizer ]
and I need to get innerHTML data, variable formula, multiple step .....if then else ......... to excel sheet.
example : collect some data from 1 to 30 webpages in each minute , each webpage data is variable,
need define which formula suitable for put to use, and compare together.
I already set table query collect data on worksheet , but very slow............Anyway, have an idea and method can force to close iexplore.exe ?

[thiskeep]

Hi Leith Ross

Thanks for your response.

Okay work , no need manual to close it.
After click STOP, then click RUN again during iexplore.exe will be continue loading [ haven't hanging happen ]

Excel 2003 API Call

Please Login or Register  to view this content.

[Leith Ross]

Hello thiskeep,

Are you trying to stop Internet Explorer while it is still loading?

[Leith Ross]

Hello thiskeep,

Are you trying to stop Internet Explorer while it is still loading?

[thiskeep]

Hello thiskeep,

Are you trying to stop Internet Explorer while it is still loading?

click ESC stop , waiting 3~4 second, iexplore.exe have not closed shown in task, and memory stay 37,000KB +/- ,
then click F5 RUN restart marco , the iexplore.exe continue load and memory increase. [ haven't hanging happen ]

Please Login or Register  to view this content.

[Norie]

Just curious but why do you appear to have an infinite loop?

[thiskeep]

Just curious but why do you appear to have an infinite loop?

the code is testing my ie memory.
I need testing my ie memory, I don't like for/next.
infinite loop purpose collect variable data refresh in each minutes
and their URL address allocate updated at different times. so.........

[Leith Ross]

Hello thiskeep,

I don't understand. What is the code doing?

[thiskeep]

Hello thiskeep,

I don't understand. What is the code doing?

collect stock data to calculate, in each minute auto output different excel chart to compare.