Hello! I try to perform a very simple task using Bloomberg and Execl. I have
an Excel spreadsheet that contains a list of bank names, their ISIN codes and
their Bloomberg tickers. I then have a macro that I (am trying to) use to
extract ratings for these banks from BBL into Excel. I use a simple DDE
connection (I know it sucks but we are not allowed to use Active X due to
security reasons and I cannot use C or other languages so I am pretty much
stuck with this). Anyway my code opens a DDE link to BBL, loops through the
ISIN codes and asks BBL for the rating that is then displayed in the
spreadsheet. This works fine. However for several reasons I would like to use
the BBL tickers instead of ISIN codes. When i try to do that my code does not
work. I get Error: #/N/A Sec (I know that they are valid tickers eg BNP FP).
Please help me with this problem! I have tried using the BBL helpdesk but
even for this easy question they cannot help me!!

BBL = "BNP FP"
channelNumber = Application.DDEInitiate(app:="BLP", topic:="S")
BloomQuery = "'" BBL & " Corp, [RTG_SP]"
returnList = Application.DDERequest(channelNumber, BloomQuery)
Rating = returnList(1)
MsgBox Rating

Please I would really really need help with this! Any help appreciated!
Thank you very much in advance!!