Has anyone managed to get SeoTools working with VBA in Async mode? I've tried all sorts of things without success.
The main problem is that Excel doesn't start fetching data after I've inserted the formula in a cell. If I put a breakpoint in the code and break immediately after inserting the formula, I can see that the formula cell is stuck on "#GETTING_DATA", no matter how long I wait. If, while still in break mode, I select the formula cell, click in Excel's formula bar, and press Enter, then fetching begins. But I can't find any way to produce this behaviour in VBA.
One thing I tried is to make the macro terminate (exit) immediately after (a) inserting the formula in the cell, and (b) using Application.OnTime to schedule another macro to run, while leaving the worksheet open. In this case fetching begins after the first macro has exited. This works, but only if I delay execution of the second macro until after fetching is complete. That means having to predict in advance how long fetching will take, which isn't practical.