2 easy ones...

neo · Mar 10th, 2002, 10:16 AM

I know these are easy, but I've had a headache over them and I was hoping someone may know the answer.

First, is there a way to close excel through VBA? All I can get to close is a workbook, but I need Excel itself to close...

And second, is there a way possible to clear the addresses out of the default web browser's (ie5, aol, whatever...) drop down explorer bar using VBA? you know, the one at the top of the browser that show the recent web sites you've been to? I know how to delete file, but I can't find where those are stored... when i clear the history folder, the addreses still appear...

Thanks to anyone who can help (c:

neo

dk · Mar 10th, 2002, 10:32 AM

Well the first one is fairly straightforward:-

Application.Quit

As for the second bit, not so sure. IE can be programatically controlled through automation but you wouldn't be able to use the same techniques with non Microsoft products such as Netscape.

Regards,
D

Jack in the UK · Mar 10th, 2002, 12:56 PM

Hi

IE like Java and HTML not VB or VBA, not know a fix to this...

Netscape will not like VBA or VB, regardless. MS software has a habbit of likeing only Microsoft software, all different languages.

Netscape will java and HTML aswell as these languages are kinda web standraads.

HTH

Rdgs
>>>>>>>>>>

Mar 10th, 2002, 12:56 PM	#3
Jack in the UK Board Regular Join Date: Feb 2002 Posts: 3,065	Hi IE like Java and HTML not VB or VBA, not know a fix to this... Netscape will not like VBA or VB, regardless. MS software has a habbit of likeing only Microsoft software, all different languages. Netscape will java and HTML aswell as these languages are kinda web standraads. HTH Rdgs >>>>>>>>>> __________________ Free Excel based Web Toolbar available here. Jack in the UK J & R Excel Solutions "making Excel work for you"

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 10th, 2002, 10:16 AM	#1
neo New Member Join Date: Mar 2002 Location: Birmingham, Al Posts: 19	I know these are easy, but I've had a headache over them and I was hoping someone may know the answer. First, is there a way to close excel through VBA? All I can get to close is a workbook, but I need Excel itself to close... And second, is there a way possible to clear the addresses out of the default web browser's (ie5, aol, whatever...) drop down explorer bar using VBA? you know, the one at the top of the browser that show the recent web sites you've been to? I know how to delete file, but I can't find where those are stored... when i clear the history folder, the addreses still appear... Thanks to anyone who can help (c: neo

Mar 10th, 2002, 10:32 AM	#2
dk MrExcel MVP Join Date: Feb 2002 Location: Sydney, Australia Posts: 2,908	Well the first one is fairly straightforward:- Application.Quit As for the second bit, not so sure. IE can be programatically controlled through automation but you wouldn't be able to use the same techniques with non Microsoft products such as Netscape. Regards, D