refreshing web queries
 

I placed web queries in my worksheet. And I run this simple macro and it is
working

Activeworkbook.refreshall

I can see the earth rotation symbol for some seconds. But if I placed other
commands next to this (to change .csv file to excel) the program skips the
above command and it start executing next line I cannot see the earth rotation
symbol. Help me to come out of this problem

refreshing web queries
 

Make sure the queries are set not to allow background queries.

--
Regards,
Tom Ogilvy


"ezil" wrote:

I placed web queries in my worksheet. And I run this simple macro and it is
working

Activeworkbook.refreshall

I can see the earth rotation symbol for some seconds. But if I placed other
commands next to this (to change .csv file to excel) the program skips the
above command and it start executing next line I cannot see the earth rotation
symbol. Help me to come out of this problem