I've been using the latest Beta versions of 64-bit SeoTools and have been mostly satisfied with the product's development. However, the new asynchronous functions work great for small sets of ad hoc queries, but they don't behave well within VBA scripts.

I've developed many projects using SeoTools and VBA to automate data collection and reports. Most of my scripts have to loop over hundreds (sometimes hundreds of thousands) of URLs to 1) apply formulas, 2) recalculate the active sheet, then 3) flatten the formulas.

Unfortunately, the async functions don't seem to report their calculation status to Excel as previous versions of SeoTools always have. When the scripts recalculate the active sheet, they proceed to copy and paste as values the current set of formulas, but those formulas haven't completed or are still in the #GETTING_DATA status. I've tried various combinations of recalculates, doevents and sleep delays (even for 15+ minutes!), but nothing has worked as of yet.

I just tried the latest v6.0.3 general release, but still no improvement, so I'm forced to continue using v5.1.4 since it's the latest reliable version.

Is there any way to disable asynchronous mode and reinstate the previous behavior, perhaps within HttpSettings() or even within SeoTools.config.xml?

Hey Victor - could you forward the 5.1.4 version to me as well if you still have it - am trying to upgrade but finding rewriting all my scripts pretty rocky…it would be much apprecated - thanks! - tedives@gmail.com

Also, what works really well for me with VBA is to output SeoTools formulas “as formulas” then copy paste the ranges as values after completion. An easy way to know when the calculations are complete is to use a counter which counts number of cells containing “Loading_Data”.

I think what I mean is, 6 years ago the =GoogleAnalytics connector had a different number of parameters, or a different set of them. I don’t remember that DEFAULT being at the end, and I used to have to specify 1,10 for 10 results, but now the “1,” is extraneous. I think one parameter was dropped and another one added (the “DEFAULT” one is optional though, it looks like).

It would be helpful if the connectors had a little help documentation as far as - what are the parameters? Current approach is to just insert the formula and examine what came back, usually you can figure it out, but explicitly explaining the parameters somewhere would speed the process of figuring things out.