how to close active ie browser using a macro
 

Hi all,

new to the group.

I'm having a bit of trouble trying to close an IE browser. I've
created a form that, once a button is pushed, copies delimited data
from a url address and pastes it into my active worksheet. Everything
works perfectly, but I can't seem to kill the browser that was opened
to retrieve the data.

Is there a simple solution that will close the active IE browser ?

Thanks,

James

how to close active ie browser using a macro
 

Hello James,

You didn't say if you open the browser maunually (click on it) or
through VBA in Excel. In either case, you will need to a couple of API
calls to accomplish the task.

It would help to know how the browser was opened as this will affect
the API calls needed to accomplish the job. Repost your answer and I
will give you the API code to paste into a VBA module. As far as I
know, the simplest method of closing the browser is to click on close.

Sinecerly,
Leith Ross


--
Leith Ross
------------------------------------------------------------------------
Leith Ross's Profile: http://www.excelforum.com/member.php...o&userid=18465
View this thread: http://www.excelforum.com/showthread...hreadid=476064

how to close active ie browser using a macro
 

Hi Leith,

I've opened the browser through a macro using follow hyperlink. My
macro then copies the delimited data from the web and pastes it into my
worksheet. Thanks for the response !!!!!

James