Share via

query timeout in excel vba

Anonymous
2013-04-03T22:36:30+00:00

I am using excel vba. 

My code runs several web queries. In case a particular query takes too much time, how can I instruct excel to timeout query after specific time (for example, 10 seconds), so that vba can continue to process remaining code. 

Thanks! a million for any help.

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Andreas Killer 144.1K Reputation points Volunteer Moderator
    2013-04-04T14:05:27+00:00

    Set the BackgroundQuery property of the query to True to continue your macro immediately.

    Andreas.

    Was this answer helpful?

    0 comments