Wait Until Internal Refresh by Website is Complete

Hello all

I am currently clicking on a button to perform a search on a website.

I want to know how I can tell using VBA when this search has finished.

I am currently using the below code BUT it is does work in the above scenario.

Please Login or Register  to view this content.

I have tried doing a search for a hyperlink which I know will appear after the search has finished BUT I got a "runtime error 70 permission denied" in my code.

When the search is being performed an image comes up and then disappears when the search has been completed. Would it be possible to check when it has disappeared as this would tell me that the search has completed?

Any thoughts would be greatly appreciated.

Regards

Jim

Hi Jim,

I'm not good enough to know the nuances of Internet Explorer automation. Occassionally (especially with web sites that use Java script) I can get by with the following code (when I know what the URL is supposed to be:

Please Login or Register  to view this content.

The above code is usually preceded by a time delay, or inside a loop.

I hope this helps.

Lewis

Thanks Lewis - I have just tested it but the problem is the expected url changes BEFORE the page has finished searching so defeats the object.

Anyone else got any ideas?

Jim

Hi,

instead of the first line code with ie.Busy try this one : Do: Loop Until ie.ReadyState = 4

Originally Posted by Marc L

Hi,

instead of the first line code with ie.Busy try this one : Do: Loop Until ie.ReadyState = 4

I tested it but it closes IE!

Any other ideas?

When all else fails, I use a 'wait' command longer than the longest time the website takes to complete. I hate doing this, because:
a. It makes me feel inadequate.
b. It takes a long time.
c. It doesn't always work.

Lewis

There must be a way of checking if the page's status is not doing an internal refresh?

Sure ! It depends on the Web page structure, you have to inspect it …

Originally Posted by Leith Ross

Hello Jimbo77,

The problem stems from Internet Explorer running asynchronously. This means VBA and Internet explorer not interlocked when it comes to code execution.

Normally in VBA, when a Sub or Function calls another Sub or Function its address is placed on the return stack. This enables the other thread to execute and when finished, VBA picks up at the next command in the procedure.

There are ways to check if Internet Explorer has finished processing but they are slow. There is another way that might work for you. You can directly access the underlying code of Internet Explorer by using the XML HTTP Request object. This will run synchronously with your VBA code.

If you can describe in more detail what you are doing, I can tell you if this option would work.

That sounds fantastic. What information do you want me to supply in order for you to establish whether XML HTTP Request object will work?

Yes it does so I obviously can't give these out.

I want to be able to extract data and also input data on to forms.

If it is simpler - is there some code that will detect once the webpage has finished its internal refresh? I could perhaps post some html from the page for that?

After I click a 'filter' button on the website, it performs a search for the information with a graphic of a yellow rotating circle and the caption "Please wait search in progress". I think from looking at the html code it does search for 5 seconds and then refreshes the page and then repeats this process until the requested data is retrieved and then it is displayed.

I want to know how to delay my code until this internal search is completed and the data has been displayed.

Leith

I tried the below code but when the search is completed the code gets stuck in an infinite loop and does not move on...

Please Login or Register  to view this content.

Tried this but still got stuck in the second loop...

Please Login or Register  to view this content.

Tried this but now does not wait until search has completed...

Please Login or Register  to view this content.

The following works for me using Vista (32 bit or Vista 64 bit), Excel 2003, and IE 8:

Lewis

Please Login or Register  to view this content.

Thanks Lewis - what is the purpose of the code?

The code opens the web site using Internet Explorer.

The 'DiagnosticDebugDotPrint()' routine displays information about the web site, some of which may be useful in your quest to find out if the web site is done doing whatever web sites do.

I hope this helps.

Lewis

Hi Jimbo77,

Did you got any solution for the above problem.

I'm stuck with the same problem and have tried almost everything that is available on internet.

Pratik

Originally Posted by FDibbins

pratik.daphal welcome to the forum

Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.

Thanks Ford!
I was not aware of the Forum Rules..:P

I will start a new thread and would also provide a link of this thread, because I find this is similar to what my problem is..

Regards,
Pratik Daphal