I have searched high an low to no avail. Perhaps someone can come up a better soltuion than what I have?
I am accessing a webpage to run a parse of some data for reporting. Everything works great including the .ReadyState and .Busy up to this point. When I click to run the report in the browser (line 2) the page opens my report with the data I need in Frame(0). The issue is that is passes the .Busy status but Frame(0) is not loaded. When I debug I confirm this with a status of "loading".
I tried Do while .document.frames(0).Docume
ate <> "completed": Doevents: Loop by iteself and it gives me a runtime error 70 "Access Denied". For some reason the Sleep function gives it just enough time to work.
However, I am not comfortable using the Sleep function since it can be affeted by the network speed of the user. Any ideas on how I can actually check the true state of the Frame to ensure it is completed before setting the Table object?
Do While .Busy: DoEvents: Loop:
Do While .Document.frames(0).Document.ReadyState <> "complete": Sleep 500: Loop
Set Table = .Document.frames(0).Document.Body.parentElement.getElementsByTagName("TABLE")
For Each Row In Table(12).Rows