Opening multople tabs in IE from Excel and VBA

[misterpinkey]

Thank you for your help, I have tried both versions of the function, but I am getting the same problem.

Now I either get exactly the same error, or sometimes it gives an error on the busy method instead of the navigate2 method

Method 'Busy' of object 'IWebBrowser 2' failed

It's the intermittant nature of this issue that is so frustrating.

Could this be something to do with the network settings I am using? I am doing this at work and the network is pretty locked down, might it be timing out and breaking the connection between Excel and IE so quickly?

Did you ever find out what the issue was? I am experiencing a very similar issue on the intranet at my work. I received the same error when running my macro, but when stepping through the code, it looks slightly different :

vba run-time error '-2147467259 (80004005)':
automation error
unspecified error

I try opening 2 windows with 7 tabs each and they both only open anywhere from 2 to 4 tabs each time I try. When stepping through the code, it always errors out on the first attempt to open a URL in a new tab instead of new window (objIE.Navigate2 strURL, 2048).

Thanks,
MP