Hi,

I need help to compile a VBA to copy a Bloomberg screen, paste into an Excel Spreadsheet, then some text formatting.


According to Bloomberg there is no "Copy" command , ie CTRL+C keystroke via VBA to a Bloomberg window does not work.

I've seen old threads about a year ago discussing the same issue. But it looks like there was no conclusive answer. Would really appreciate it if anyone could shed light on this.

Thanks in advance

Hi

From Bloomberg you can create xls, csv, txt files. Importing them in Excel through VBA is quite easy.