Hi All,I am currently working into Strategy team, and am supposed to do some automation in an excel sheet to make life easy. I need to pull some data from Bloomberg to Excel using VBA code. but the kind of data that i want to pull won't be using BDH or BDS or BDP function. For example: if you put CCTS Govt in bloomberg, you will get securities list. this securities list can be dragged down to excel sheet, but thats a bit tiring. So i want to automate this process so that as soon as i open the excel file/ click on a button, it gets updated automatically. Any kind of help will be very much appreciated,Thanks

Don't post the same question in multiple subfora

Press "Help" on your bloomberg keyboard. Then press "Help" again. This will open Bloomberg's help desk chat window.