I got a macro that is trying to populate a table with information from an outside source (Bloomberg), but the macro runs so fast it doesn't have time to populate.
I'm trying to find a way for the macro to pause so that the data can finish loading before it saves and exits.
I've tried application.wait and it paused, but it pauses the whole procedure of the data loading also.
Can anybody help or have any suggestions? Thanks .
Last edited by jcb0806; 06-14-2010 at 04:46 PM.
......... bump
It would help if you had placed you code here.
Please Login or Register to view this content.
you can also use this.
this will delay for 1 second and automatically resumePlease Login or Register to view this content.
Originally Posted by Weezy
you can also use this.
this will delay for 1 second and automatically resumePlease Login or Register to view this content.
Thanks Weezy,
But I've tried that "Application.Wait" and it pauses everything in excel, even the data from loading from bloomberg. Thats what I currently have in my vba code
Please Login or Register to view this content.
Re: Bloomberg Populate Table MACRO
I found something that worked for me thought.
I used the "ontime method"..I just split the macro into two.
While the first macro waited for whatever time (20 seconds) I put in the "ontime method" the fields were able to load in and then the second macro ran and saved the spreadsheet for me.
Avoid using Select & Activate in VBA
improvement:
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks