This is a VBA class module of a Bloomberg API Wrapper. The features of this wrapper include requesting historical (BDH) and reference data (BDP) from Bloomberg.

Excel, Bloomberg API COM 3.5 Type Library

• Create a macro-enabled spreadsheet, in reference enable Bloomberg API COM 3.5 Type Library.
• Insert a class module, name it "Bloomwrap" ( or whatever you prefer ), paste whole VBA_Bloomberg_API_Wrapper into the class module.
• Insert a module, paste test file contents into the module.

In test module, run macro try1, try2, try3 on a bloomberg terminal, the tests show examples of how to use the Bloomberg Wrapper class.

Please read Bloomberg API Library for the original API application this project is built above.

• Yingke Yu yy2792