Tweet
I'm using qlink to import real time futures data into an excel spreadsheet so that I can calculate some custom technical indicators. I'm trying to automate the process with VBA but I've hit a snag. I have VBA code that begins the data retrieval process and which is followed by vba code that processes the data. The problem is that excel moves on to my processing code while the data is still coming in and in the process suspends the data retrieval. Any code I insert to cause a delay also suspends the data retrieval. The only way I can deal with this right now is to manually start the data processing after the data retrieval is complete. As I said I need to automate this. Any thoughts as to how to suspend vba code execution until the dde links update is complete?