dlbatsford
New Member
- Joined
- Sep 29, 2006
- Messages
- 1
Hi,
in my VBA im using code to pull in a data field from Bloomberg. this is done viia bloombergs DDE server which runs when i open Excel.
the code is
Range("w4").Formula = "=BLP|M!'" & ticker & " EQUITY,[VOLUME_AVG_10D]'"
This can take a good 3 seconds to pull in the data, the problem i have is that it doesnt start to pull in the data until my macro/sub has finished but i need to use the information it pulls in before the macro finishes. (hope that makes sense)
Ive tried delaying/looping etc but it doesnt free up to update from external dde links.
im not hugely techy so if ive left anything out just tell me what you need. Thanks in advance to all who reply.
Darren
in my VBA im using code to pull in a data field from Bloomberg. this is done viia bloombergs DDE server which runs when i open Excel.
the code is
Range("w4").Formula = "=BLP|M!'" & ticker & " EQUITY,[VOLUME_AVG_10D]'"
This can take a good 3 seconds to pull in the data, the problem i have is that it doesnt start to pull in the data until my macro/sub has finished but i need to use the information it pulls in before the macro finishes. (hope that makes sense)
Ive tried delaying/looping etc but it doesnt free up to update from external dde links.
im not hugely techy so if ive left anything out just tell me what you need. Thanks in advance to all who reply.
Darren