But CTRL-C is expressed as^CWhat you have there is ALT-C

I am courious why sendkey is important. just courious!

This seems to work, but it is fiddly. I have some tickers on my Excel sheet and I want to get the DES page and paste that in.There is a Bloomberg sample sheet 1039652.xls which shows how to use the DDE server directly.I've found that if you use Application.SendKeys to talk to Bloomberg to find the ticker, and then send a "DES", you can use the DDE server to make a copy to the clipboard with the key sequence "<alt->c<alt->". And then sleep for 2000 and you should be able paste special.I found that I had to use a DataObject and then GetFromClipboard.I could go into more detail, but it is fiddly.

The manual page on SendKey says that "^c" is Control-C and the "%c" is Alt-C.Neither works. I did find a way of doing with the DDE server.

J,About the Bloomberg console, you can get information from it in many ways. The Bloomberg Excel add-in allows you to access many defined fields via the DDE server.A lot of useful information seems to be only accessible as a sheet on the Bloomberg console itself. The only way you can obtain that is to talk the Bloomberg console. That's why I had to use Application.SendKeys from Excel. To get a copy of a sheet, you can use Alt-C, but Application.SendKeys doesn't seem to send that key sequence correctly.There are other ways of getting data from the database underlying the Bloomberg console (they have a data server, you can get a licence to get downloads from an FTP server), but getting copies of pages is only possible by using SendKeys.

J, there are many tasks that cannot be done though the BB APIsActually, that's not quite true...There are tasks that BB does not volunteer info on how to do, and it is easier to use an unsupported, nearly undocumented, and inherently flaky programming technique than to get them to tell you how to do it.

There is an api to communicate with the terminal. you can do all sort of things you normally do on the terminal, including <cancel> screens, tabs, shortcuts and any combinations of commands. if you are interested let me know.

Hi, could you give more details ?

Or at least a hint of the direction we could investigate ?

Hi,I have a related question and thought I add to this thread instead of starting a new one...Is there a way to test via VBA or API when the Bloomberg window is open -BUT I have not logged in?Note: I do not want to test whether there is a Bloomberg window open. I want to test whether I'm logged in or not.Thank yourhk

You need the Win32 API GetPixel A surprisingly robust solution is to get the hDC for the desktop (it's just another window) and query the colour of the pixels. You only need to locate a few that are different between the logged in and disconnected state.