Bloomberg API Query via VBA

I need to return field values from multiple securities (tickers) via a login to a Bloomberg terminal. An example of a ticker to return data for is CLOU US Equity For this ticker I need to return the following field as an example - Sector holdings and their respective weights The BQP formula for the above is - =BQL("members('CLOU US Equity',type=holdings)","sum(group(id().weights,gics_sector_name))","cols=2;rows=10") As well as the above, there are other BDP queries to perform as well as BDS and BQL queries. The issue to resolve is the refreshing of the Bloomberg formula to return the required field data when the VBA is performing a loop of tickers. When conventional VBA code is used such as [login to view URL], the data is not returned and the Bloomberg API need to be interacted with in order to force the refresh. Using the formula directly in a call doesn't refresh the data until the VBA procedure has fully executed and finished. The fee will be paid upon successful deployment with the specified formulas above working within a loop.