ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Internet Exlporer and Vista (https://www.excelbanter.com/excel-programming/424854-internet-exlporer-vista.html)

J Streger

Internet Exlporer and Vista
 
I have code that, in Windows XP, would go out and upload or download
information to a web page using the web pages GUI. This code still works fine
in XP, but using it on a vista machine causes the code to fail. I cannot keep
a handle on the internet explorer object if I navigate away from the page
more than once. Of course if that happens I can no longer manipulate the page
and my code fails. I realize they changed how IE works in Vista, so does
anyone know of a working method to do this. I need to navigate using the
links, and click the objects in the browser, since I don;t want the code to
have acces to anything else. here is a sample of the code I'm using:

Sub UploadToIE()

Dim ieBW As InternetExplorer

Set ieBW = New InternetExplorer
ieBW.Navigate2 "www.Google.com"
ieBW.Navigate2 "www.microsoft.com"

'This is where the code fails as it no longer knows what ieBW is
Do
DoEvents
Loop Until ieBW.ReadyState = READYSTATE_COMPLETE And Not ieBW.Busy

End Sub


Thanks for any help!

--
*********************
J Streger
MS Office Master 2000 ed.
MS Project White Belt 2003

User of MS Office 2003



All times are GMT +1. The time now is 01:46 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com