Any out there use Bloomberg

scheer

Newbie
Messages
1
Likes
0
I am trying to set up some VBA code in Excel to send commands to bloomberg window using DDE. Example code below works most of the time, but sometimes it just completly locks up Excel and I have to kill the excel process through task manager. A restart will fix the problem, but has anyone else worked with DDE with Bloomberg?

blp = DDEInitiate("winblp", "bbk")
Call DDEExecute(blp, "<blp-0>ID " & Cells(ActiveCell.row, 3).Value & "<GO>DES<GO>")
Call DDETerminate(blp)
 
Top