Any out there use Bloomberg

[scheer]

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)

 

[grantx]

GJ,

Ask her to untie you.

Grant.

 

[gbuschner]

Do you still need help with that?