Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 8
Default quit ie from excel macro

Hi...

I'm running a macro that opens internet explorer....then tries to quit ie...

Dim ie As InternetExplorer
Set ie = New InternetExplorer
ie.Navigate "http://url is here"
'Do Until ie.ReadyState = READYSTATE_COMPLETE
'Loop
Application.Wait Now + TimeSerial(0, 0, 2)
ie.Quit

Gets what I want but doesn't quit ie....This is with vista & office
2007....if I take ie.Quit out, it will work but I end up with a lot of tabs
open in ie....I have IE7 set to reuse tabs, but excel still opens a new tab
every time...

On another computer this works fine, XP & office 2007. In that I can use
the ie.ReadyState, without the wait. Internet explorer doesn't even become
visible..
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
can't quit excel maven Excel Discussion (Misc queries) 0 March 15th 07 12:31 AM
Excel instance won't quit [email protected] Excel Discussion (Misc queries) 0 September 6th 06 06:57 PM
Excel application.quit in macro problem TimkenSteve New Users to Excel 3 August 17th 06 06:36 PM
Excel won't quit JRS Excel Discussion (Misc queries) 1 September 27th 05 04:31 AM
Excel Quit opening DaCmanLou Excel Discussion (Misc queries) 0 February 6th 05 08:19 PM


All times are GMT +1. The time now is 10:51 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"