If Bloomberg is closed, EXCEL should ask you if you want to update the
links and will turn on the DDE "engine", to enable EXCEL to update the
links. In any case, Bloomberg has very good help services,
online(through the terminal itself) I suggest you use them rather than
an EXCEL forum.


Viktor Ygdorff wrote:
Ok my situation is like this: I have a computer that runs Windows XP
Professional. On the computer I have a Bloomberg subscription i.e. I have an
ordinary monitor, but a Bloomberg keyboard and it is "true" Bloomberg
subscription (it is not the Bloomberg website I am referring to). I have an
Excel spreadsheet that is connected to Bloomberg and updated once every day
using a DDE connection. Now will this work even if the Bloomberg program is
closed? If not so is there any other way of creating a link that works even
if the Bloomberg program is closed? The connection works through a macro that
runs on a prespecified time every day. The code for opening the Bloomberg
link is:

channelNumber = Application.DDEInitiate(app:="BLP", topic:="S")

(the code for the macro is not written by me)