Hi

Im making a master excel spreadsheet using VBA which extracts a single cell from multiple excel files connected to Bloomberg.

My problem is that the no matter what I do it will open, copy and close the files before it has a chance to update its values from Bloomberg. Adding a pause in between the code seems to pause the update as well and if i leave the files open (by removing the workbook.close), and step through the code, they only seem to update when the code has completely finished executing. I've been searching for two days now for a solution online but none of the answers seem to work or be very clear.

Does anyone know how to solve this? My code is essentially just an

open file
application.run "bloombergui.xla!RefreshEntireWorkbook"
code to copy
close file

Thanks!