PC Review


Reply
Thread Tools Rate Thread

ActiveWorkbook.RefreshAll waiting time

 
 
Vit
Guest
Posts: n/a
 
      17th Nov 2008
Hi all!

I'm working with Excel 2007 and using the data connection function to
connect to a SQL server as a source...

I'm woking on a VBA code that have to update the connection and
perform some calculation on the data....

unfortunately, the updating process (ActiveWorkbook.RefreshAll) is not
finished when the code is performng the calculation...

it is possble to insert a "waiting time" after the
ActiveWorkbook.RefreshAll ????

any other suggetion???

thanks all

cheers

Vit
 
Reply With Quote
 
 
 
 
brian.baulsom@gmail.com
Guest
Posts: n/a
 
      17th Nov 2008
You could try the one-liner
DoEvents
or - for 10 seconds -
Application.Wait Now + TimeValue("00:00:10")
 
Reply With Quote
 
Vit
Guest
Posts: n/a
 
      17th Nov 2008
Thanks for your replay, I have understod the Application.wait Now +
TimeValue("00:00:10")

but how can I be sure that the update process is finished???

what about DoEvent??? how does it work???

thank you so much....
vit



On Nov 17, 8:24*pm, brian.baul...@gmail.com wrote:
> You could try the one-liner
> DoEvents
> or - for 10 seconds -
> Application.Wait Now + TimeValue("00:00:10")


 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
ActiveWorkbook.RefreshAll Problem Troy Munford Microsoft Excel Programming 0 26th Jun 2008 04:44 PM
ActiveWorkbook.RefreshAll =?Utf-8?B?TWF0dCBDcm9tZXI=?= Microsoft Excel Programming 3 24th Jul 2006 08:45 PM
ActiveWorkbook.RefreshAll =?Utf-8?B?bmM=?= Microsoft Excel Misc 0 21st Mar 2006 10:50 AM
ActiveWorkbook.RefreshAll toosie Microsoft Excel Programming 1 16th Feb 2005 09:55 AM
ActiveWorkbook.RefreshAll Mark Microsoft Excel Programming 0 15th Oct 2003 02:22 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 10:07 PM.