| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Not Refreshing | Excel Discussion (Misc queries) | |||
| still need help refreshing Web stats | Excel Discussion (Misc queries) | |||
| NOW() and SECOND() not refreshing | Excel Worksheet Functions | |||
| refreshing cells? | Excel Discussion (Misc queries) | |||
| Problems refreshing internal queries in excel | Excel Discussion (Misc queries) | |||
Linear Mode
