Macro to refresh workbook connections
 

Hi, I need a macro to refresh all workbook connections and then save and close the file. The connection information is present in .odc files. My problem is that the macro moves to the next step before the refresh is complete. I noticed that by default the 'Enable background refresh' checkbox is...