Hello, all!
I'm running a procedure that loops through a series of records in a Word document. Part of it involves opening IE and navigating to a URL.
If IE runs Visible, the code runs perfect. If it runs NOT visible, at a random point (sometimes 14 records, sometime 90), it suddenly encounters an error on the "Navigate" command (something like "the remote application does not exist or is busy").
Here is an excerpt of the code:
[vba]
strURLtest = "https://unx1.shsu.edu:9443/login?" _
& "url=http://atoz.ebsco.com/titles.asp?lang=en&id=8808&KW=" _
& strTitle & "&SF=Titles&ST=Exact"
Set appIE = New InternetExplorer 'WIN XP
'appIE.Visible = True
appIE.Navigate strURLtest
Do Until Not appIE.Busy And appIE.ReadyState = READYSTATE_COMPLETE
Loop
strSearchText = "Titles where title name exactly matches '" & strTitle & "': 0"
[/vba]
I can't understand why the error occurs only when IE runs not visible, and why it occurs at random, never on the same record. I'm likely doing something wrong--I'm still an amateur.
I've attached the Word doc with the complete procedure (ReplaceURL); please be aware though that the URLs in the code require login or approved IP, so testing might be difficult unless you change the URL. For further info: this is running on Windows XP, in Word 2007, using IE version 7.0.5730.13.
Many thanks in advance!!!
~eed