Instantiate Internet Explorer in Outlook VBA

P

Pierre Scerri

The following code works well with Outlook 2003 in Windows XP and Vista:

Set Iexplr = New InternetExplorer
With Iexplr
.Visible = False ' Hide the browser
.Navigate URL:="http://anywebsite.com/" ' go to the website

Do While .Busy: DoEvents: Loop ' Wait for the page to load
etc...

With Outlook 2007 and Vista, the .Visible command has no effect. The
..Navigate command opens a visible Internet Explorer, goes to the appropriate
website and makes the 'Iexplr' variable null. The .Busy command then fails
with Runtime error 462 and execution stops.

Any suggestions would be most helpful. Thank you.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Outlook 2003/2007 differences 2
Handling internet explorer memory leaks from Excel VBA 0
Internet Explorer Object, Navigation, Hiding 6
Run time error when accessing Internet using VBA 4
Internet Exlporer and Vista 0
Copying from internet explorer 1
Handle Pop-Up While Navigating with IE 0
IS INTERNET EXPLORER 8 COMPATIBLE WITH OUTLOOK 2002 3

Top