Hello all, I'm new to VBA and writing macros, but have set up a project where I've 50 workbooks, all with live data feeds from Bloomberg, in a folder. For the feeds to be updated, the workbooks must be opened, refreshed, saved, and then closed. I need a macro that would automate this task for all 50 workbooks, but my current macro saves and closes the books before they get a chance to update. I tried working with a time delay, but this seems to pause ALL Excel calculations/operations.

Any help would be greatly appreciated.