Dear All,

this seems like a common problem, but I have not seen a definiate
solution yet - so any help would be most appreciated.

I have some code that does a vlookup where the source data is via a web
query. Occassionally I need to refresh the web query to update the
data.

However, it appears that the code completes before the page is
refreshed, so the old data is still used in the vlookup.

When I manually step through the process (F8) it completes perfectly as
I presume the extra time I take enables the web query to refresh in
time.

Any ideas how I can ensure that the refreshing is completed before the
remainder of the code is finalised?

Regards,

andym

try
application.enableevents=false
code
application.enableevents=true

--
Don Guillett
SalesAid Software

"andym" wrote in message
oups.com...
Dear All,

this seems like a common problem, but I have not seen a definiate
solution yet - so any help would be most appreciated.

I have some code that does a vlookup where the source data is via a web
query. Occassionally I need to refresh the web query to update the
data.

However, it appears that the code completes before the page is
refreshed, so the old data is still used in the vlookup.

When I manually step through the process (F8) it completes perfectly as
I presume the extra time I take enables the web query to refresh in
time.

Any ideas how I can ensure that the refreshing is completed before the
remainder of the code is finalised?

Regards,

andym

Make sure the QueryTable.BackgroundQuery property is set to False. Can be
done wither in code or by right-clicking on the querytable result range and
choosing Properties. Background queries allow other processing to occur
before the results are returned.

--
- K Dales


"andym" wrote:

Dear All,

this seems like a common problem, but I have not seen a definiate
solution yet - so any help would be most appreciated.

I have some code that does a vlookup where the source data is via a web
query. Occassionally I need to refresh the web query to update the
data.

However, it appears that the code completes before the page is
refreshed, so the old data is still used in the vlookup.

When I manually step through the process (F8) it completes perfectly as
I presume the extra time I take enables the web query to refresh in
time.

Any ideas how I can ensure that the refreshing is completed before the
remainder of the code is finalised?

Regards,

andym