I’m stuck on something and i cannot figure out how to resolve it.
I got some code that calls a Dump formula (using Twitter Connectors). The formula works well if i execute the code step by step (using f8). But if I run the code using F5, it fails, because the code goes faster than Dump.
I tried using Application.wait., using calculatestate, DoEvents, and a lot more of stuff. Also tried disabling and enabling the Addin, Screenupdatinng, and even a Wait time for an hour. I also tried what you can see in the help webpage http://seotoolsforexcel.com/working-with-vba/, enable and disabling Async and nothing works. I’m really lost.
It’s curioius because if I use and STOP command right after the dump, the worksheets calculates and then the code works, but the problem of using a STOP command in VBA is that an user needs to be in front of the computer to keep the code running and I want to avoid that. I want the code the code to run complete. I use DUMP but I’m not fetching a huge amount of info (around 100 rows of info, and just 1 column).
If you need more information, I’m just using connector Tweets search, and my query is really simple, because is “from:accountname since:2017-11-26 until:2017-11-27” and it’s limited to 150 results.
Is really frustrating to see that the code works PERFECT if I use a STOP command, but i cannot do it that way because i need it to be 100% auto.
Sorry about mi bad English. I hope anybody can help me, because I have no idea of what else to try.
Thanks in advance.