MattKlein
04-29-2008, 09:44 AM
Hi all!
I am having Excel pull some data from the web using CreateObject("InternetExplorer.Application"). However, one of the web pages I am trying to navigate to has IE close itself down, then open a new IE instance (so it can remove the address bar, toolbars, etc...). When this happens, my IE object pointer (sorry, not sure what its called in VB) is no longer valid. So my question is:
How can I re-grab the object pointer for this "new" IE window? (or prevent IE from closing down and forcing the web page to load in the current IE instance?)
Thank you all for your help!
I am having Excel pull some data from the web using CreateObject("InternetExplorer.Application"). However, one of the web pages I am trying to navigate to has IE close itself down, then open a new IE instance (so it can remove the address bar, toolbars, etc...). When this happens, my IE object pointer (sorry, not sure what its called in VB) is no longer valid. So my question is:
How can I re-grab the object pointer for this "new" IE window? (or prevent IE from closing down and forcing the web page to load in the current IE instance?)
Thank you all for your help!