Hi,
I have written some VBA code which calls up a Bloomberg screen and inputs the relevant data based on that entered into an Excel spreadsheet, this all works fine, however I now need to pull the results back from Bloomberg and paste the data into Excel.
According to Bloomberg there is no command line copy command so I am at a bit of a loss here, is there any way to perhaps send the CTRL+C keystroke via VBA to a Bloomberg window (I've seen articles, including some on Wilmott which suggest this might be possible but I can not get it to work).
Would really appreciate it if anyone is able to help out here as my whole project is essentially pointless unless I can pull the data back into Excel!
I have written some VBA code which calls up a Bloomberg screen and inputs the relevant data based on that entered into an Excel spreadsheet, this all works fine, however I now need to pull the results back from Bloomberg and paste the data into Excel.
According to Bloomberg there is no command line copy command so I am at a bit of a loss here, is there any way to perhaps send the CTRL+C keystroke via VBA to a Bloomberg window (I've seen articles, including some on Wilmott which suggest this might be possible but I can not get it to work).
Would really appreciate it if anyone is able to help out here as my whole project is essentially pointless unless I can pull the data back into Excel!