Programmer - Loading Bloomberg Api Data Using VBA Access Program

Programmer Question

Hi Friends,

we have subscription to Bloomberg data,
we use excel to load data from bloomberg using bdp function.
but its pain,so we decided to find easy way to do this .
Is there any way to program and calculate Fixed Income Chars from a list of securities using VBA ,access,sql or anything.?

Thanks