+ Reply to Thread
Results 1 to 9 of 9

vba to wait untill , "In Progress" website message to finish/disappear

  1. #1
    Forum Contributor
    Join Date
    04-25-2014
    Location
    India
    MS-Off Ver
    Excel pro plus 2021
    Posts
    186

    vba to wait untill , "In Progress" website message to finish/disappear

    hello friends ,

    i am using marco to navigate a website and then go to next page untill last page .
    while going from 1st page to 2nd page,shows message in box "In Progress "
    as a temporary solution i am using : Application.Wait (Now + TimeValue("0:00:20"))
    how i can ask marco to wait untill , "In Progress" is finish/disappear
    below is html code ...please help guys

    HTML Code: 
    Last edited by raj soni; 12-28-2014 at 09:51 AM.

  2. #2
    Forum Expert Tinbendr's Avatar
    Join Date
    06-26-2012
    Location
    USA
    MS-Off Ver
    Office 2010
    Posts
    2,125

    Re: vba to wait untill , "In Progress" is finish/disappear

    You'll need to create then monitor an browser object for the ready state, as in this message.
    David
    (*) Reputation points appreciated.

  3. #3
    Forum Contributor
    Join Date
    04-25-2014
    Location
    India
    MS-Off Ver
    Excel pro plus 2021
    Posts
    186

    Re: vba to wait untill , "In Progress" is finish/disappear

    hi Tinbendr , thanks but , i am new to vba language ,
    can you help you in more details ,
    i tried to find and also tried from link you from provided ,
    but end result negative ....

  4. #4
    Forum Expert Tinbendr's Avatar
    Join Date
    06-26-2012
    Location
    USA
    MS-Off Ver
    Office 2010
    Posts
    2,125

    Re: vba to wait untill , "In Progress" is finish/disappear

    Please Login or Register  to view this content.
    This waits until the browser reports the window is in a ready state. (idle)

  5. #5
    Forum Contributor
    Join Date
    04-25-2014
    Location
    India
    MS-Off Ver
    Excel pro plus 2021
    Posts
    186

    Re: vba to wait untill , "In Progress" is finish/disappear

    hello sir ,
    another way ,
    how i can ask marco to wait if <img id="ctl00_Button1_imgProgress"> is loading/or present ...
    and proceed when this img id is not present ?

  6. #6
    Forum Expert Tinbendr's Avatar
    Join Date
    06-26-2012
    Location
    USA
    MS-Off Ver
    Office 2010
    Posts
    2,125

    Re: vba to wait untill , "In Progress" website message to finish/disappear

    Sorry, that is a little beyond me.

  7. #7
    Forum Expert
    Join Date
    11-24-2013
    Location
    Paris, France
    MS-Off Ver
    Excel 2003 / 2010
    Posts
    9,831

    Lightbulb Re: vba to wait untill , "In Progress" website message to finish/disappear


    Hi,

    you can use a loop testing the element via IsObject function …

  8. #8
    Forum Contributor
    Join Date
    04-25-2014
    Location
    India
    MS-Off Ver
    Excel pro plus 2021
    Posts
    186

    Re: vba to wait untill , "In Progress" website message to finish/disappear

    hello sir ,
    i am new to vba ,
    can you help me how to write code for this ?

  9. #9
    Forum Expert
    Join Date
    11-24-2013
    Location
    Paris, France
    MS-Off Ver
    Excel 2003 / 2010
    Posts
    9,831

    Re: vba to wait untill , "In Progress" website message to finish/disappear



    See samples in VBA inner help and from this forum …

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Why does this "wait for page to load" fail?
    By hgtenn in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 02-04-2014, 01:54 PM
  2. Range(" ").Copy .......PasteSpecial.formats requires manual enter key to finish macro
    By John Vieren in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 05-20-2013, 05:31 AM
  3. Application.Wait Now + TimeValue("00:00:10"), but it stops my workbook also.
    By esbenhaugaard in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-20-2012, 04:50 PM
  4. Macro won't wait "Refresh all Pivot Tables" command to conclude before calculating
    By malalol in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-23-2010, 04:31 PM
  5. "Loading ... Please Wait" Message
    By cgi_pro in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-26-2006, 08:59 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1