Method 'Busy' of Object 'IWebBrowser 2' failed Error From Access

[jlyn123]

I am at a loss...I cant find anything online to help figure out why I am getting this error message. I have used this VBA code before (located below) and now when I try to use I keep getting this error and cant move forward. The website opens and I can sign in but the coding is supposed to processing items when I log in but I cant get past this spot.

Any help would be greatly appreciated.

Public Function FnWaitForPageLoad(objIEBrowser)
Do While (objIEBrowser.Busy Or objIEBrowser.READYSTATE <> 4)
DoEvents
Loop

End Function

Thanks!

 

[james_lankford]

try this answer

https://stackoverflow.com/questions/17480369/vba-hanging-on-ie-busy-and-readystate-check

 

[jlyn123]

Hello, I am still not getting anywhere with this code. If I use what is provided in the above thread I still get the same error message. What is strange is I am using the same coding in a different database for a production website and everything works fine. This is a website for a testing website - would that make a difference? Only difference is the url? It will reach the login page but once it gets to the code to look for next page it disconnects? Do you know why there would be a disconnection?

Thanks!

 

[xenou]

What is the declaration of objIEBrowser?

 

[jlyn123]

objIEBrowser is set to the below

Set objIEBrowser = GetObject("new:{D5E8041D-920F-45e9-B8FB-B1DEB82C6E5E}")
objIEBrowser.Visible = True
objIEBrowser.Navigate ("https://odmuat.acsgs.com/MarshUAT/Login.aspx")

This same code works fine with a slightly different HTTP address for the production website. Not sure what it is getting caught up on this one.

Thanks!

 

[stumac]

You say you can't get past the login page - do the login details you are using work on both the UAT and the production site?

 

[jlyn123]

Yes, they both have different logins but it works manually and with coding through production but not with coding through UAT.