Hello everyone,
I'm new around here and relatively new to VBA. I'm working on a workbook which is transmitting and receiving information on a DDE platform. I have some code written to perform various actions which is working just fine. I want to create a sub that does a few things, then transmits the results off of my workbook. It then has to wait for a response, a confirmation number. This much is working fine as well but I think the time it takes to get that confirmation number is causing the problems for me. Is there a way to cause the code to stop executing for say 1 second while it gets this confirmation number and then finish executing the sub with this new confirmation number? I tried using the Application.Wait function (and then specify how long to wait) and on the surface that works fine, meaning that excel pauses the execution for as long as I tell it to, but I'm thinking it's also suspending the data transfer as well so when it resumes execution, it still doesn't have the information (confirmation #) I'm waiting for. Is there a way to get around this? Can I pause the code execution and still receive the confirmation # I'm waiting for and then finish out the code with the new data?
Thanks, I appreciate the help.
Brennan
Bookmarks