Waiting for an external website's process to finish

[sbucelli]

Hi,
I'm relatively new to VBA Excel and was wondering how to wait for an external website's processing to finish before moving on to the next line of code in my macro.
I've done some googling but didn't quite find anything useful to my particular situation.

My macro navigates to a website and on that website is a "Process" button. I programmatically click this button but I don't want my next line of code to execute until the website's processing (it inserts a bunch of rows into a database table) is actually done.

One of the things I DO NOT want to do is 'sleep' X number of seconds. That's a no-go because the data insertion can take a varying amount of time.

Below is the relevant code snippet. Any help/ideas would be greatly appreciated.

Please Login or Register  to view this content.

[Sean Thomas]

Please Login or Register  to view this content.

[sbucelli]

Thanks for the very quick reply!
Unfortunately, I tested this and it still did not work.

Here is the code I used:

Please Login or Register  to view this content.

[Kyle123]

It's difficult to say without seeing the site, but one approach would be to loop until an element is present only when the processing has finished

[leelnich]

Hi s- is the element name spelled correctly?

Please Login or Register  to view this content.