| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
ActiveWorkbook.RefreshAll
Is there any function checking its status?
I want to open other excel file, refreshall, save, close. Save function executes during refreshing and it asks me "Do u want to stop refreshing". I want to save file, but after refreshing. Help:) Toosie |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
ActiveWorkbook.RefreshAll
toosie,
If your queries are not set to refresh in the background, VBA code will wait until the refresh has completed before continuing. Look at the Properties of the/each query. NickHK "toosie" wrote in message ... Is there any function checking its status? I want to open other excel file, refreshall, save, close. Save function executes during refreshing and it asks me "Do u want to stop refreshing". I want to save file, but after refreshing. Help:) Toosie |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| ActiveWorkbook.RefreshAll | Excel Discussion (Misc queries) | |||
| ActiveWorkbook.RefreshAll | Excel Discussion (Misc queries) | |||
| How can I control RefreshAll | Excel Programming | |||
| RefreshAll Data with VBA | Excel Programming | |||
| ActiveWorkbook.RefreshAll | Excel Programming | |||
Hybrid Mode
