Consulting

Results 1 to 2 of 2

Thread: run code after finishing web query load

  1. 07-27-2009, 12:36 AM #1
    anandbohra
    anandbohra is offline
    VBAX Mentor anandbohra's Avatar
    Joined
    May 2007
    Location
    Mumbai
    Posts
    313
    Location

    run code after finishing web query load

    Hi all,

    I have a procedure which I want to run only after updating web query in sheet2. but I don't konw how to write code which first check whether web query finished loading in sheet2 without error.

    If finished without error then execute macro1 else say problem in finished web query.

    hope u got my query.
    Always Mark your Thread as Solved the moment u got acceptable reply (located under Thread tools)
    Practice this & save time of others in thinking for unsolved thread
    Reply With Quote Reply With Quote
  2. 07-27-2009, 03:41 AM #2
    Jan Karel Pieterse
    Jan Karel Pieterse is offline
    MS Excel MVP VBAX Master
    Joined
    Apr 2006
    Posts
    1,102
    Location
    You can refresh a query synchronouosly from VBA so the next line will not be exectuted before the refresh is done:

    Activecell.QueryTable.Refresh BackgroundQuery:=False
    Regards,

    Jan Karel Pieterse
    Excel MVP jkp-ads.com
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules