I'm using a sheet using TR Eikon Office to receive data from eikon and are trying using a macro in another workbook that copies and pastes this data. The macro opens the data downloader file and copy the data to paste this into the other workbook. The problem I encounter is that the macro is faster than updating the data. So in some formulas it copies "retrieving.." Do you have a solution for this?
I was thinking about a macro that says it should update the worksheet first. Hope you can help in this.