ActiveWorkbook.RefreshAll

  • Thread starter Thread starter toosie
  • Start date Start date
T

toosie

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
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

vba code does not run 3
Is it possible to disable a single sheet for ActiveWorkbook.Refres 1
ComboBox.Enable giving error on ActiveWorkbook.RefreshAll 10
Excel Macro Problem 2
VB refresh of query 2
Why macro cannot refreshall? 7
ThisWorkbook.RefreshAll Issue/Question 1
Delay copy & paste of data until web query refreshes? 2

Back
Top