Hello everyone, I have a loop in which at one point i need to draw data in via a Bloomberg terminal. This always takes a few seconds to achieve this. Without any pause, the operation is not completed before the next step (which is to copy and paste special the data somewhere else) goes ahead. This means that the loop is not getting new data every time the loop goes around as i want it. I tried to give it time to allow the Bloomberg data to be drawn in using this code:
Sub KillSomeTime10() Dim PauseTime, Start PauseTime = 10 ' Set duration in seconds Start = Timer ' Set start time. Do While Timer < Start + PauseTime Loop End Sub But this seems to pause everything, including the Bloomberg data draw in process, so at the end of the pause the data is still not drawn in. I need some way to pause my code but in that time still allow the Bloomberg data to be drawn in. Any help would be greatly appreciated David -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
