Hi Guys,
I am trying to automate a webpage through macro. But facing some problems. I actually want to control the page with help of the progress bar.
Here is the code for the progress bar->
Can we do something like for example->
Please Login or Register to view this content.
Thanks in advance guys.Please Login or Register to view this content.
Cheers
plasma33
Try this:
But it's difficult to know if this will work without seeing the web page itself, for which we need the URL.Please Login or Register to view this content.
Post responsibly. Search for excelforum.com
Thanks for your kind reply. The above code you gave me did not work. Here is the URL for the webpage->
http://msbi.ipb-halle.de/MetFusion/
Actually I need to extract some URLs from the second tab i.e. the Query Result tab and it happens only when the Retrieval is 100%. The Query Result tab only comes up when you start and finish the Retrieval. Here is a bit of code that I am trying to implement->
Please Login or Register to view this content.
Cheers
plasma33
I had a look at this and was unable to detect the progress bar at 100% or not showing 'running'.Originally Posted by plasma33
Instead, try checking for the Query Results tab being the active tab, which only happens when the results are complete, unless you manually click it when the calculation is still running.
EDIT Even simpler, wait until the results table exists:
Please Login or Register to view this content.
Last edited by Chippy; 08-24-2012 at 12:39 PM. Reason: Thought of a simpler technique
yipeeeee....your code its working perfectly Chippy...thanks heaps......
Cheers
plasma33
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks