troubleshooting Question

Using excel with Bloomberg BLP functions

Avatar of pbo1
pbo1Flag for United States of America asked on
Visual Basic ClassicMicrosoft Excel
4 Comments2 Solutions3598 ViewsLast Modified:
I am using Visual Basic within Excel to run a Bloomberg BLP function that tells me the CUSIP of a security.  Within Excel VB I am testing for any N/A's prior to closing.  My problem is that the code only works for a small set of securities.  If I try it with a large file it appears the BLP function does not run/update any of the securities within the file.  Interestingly if I input a message box at the start of the code the BLP function/VB code runs fine after clicking on "ok" on the message box.  If I remove the message box the BLP functions does not seem to run.  As mentioned at the start if there only a few rows of data the code runs fine.

I have taken a look at a few of the other posts on the site regarding BLP/Excel in terms of timers, etc. but I have the same results as explained above....

Thanks in advance.
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 2 Answers and 4 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 2 Answers and 4 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros