Cache issues in SeoTools 6.0.x when used in VBA Macros

Hey there.

I use SeoTools to go through links in bulk and check if a keyword is found on their source code.

But I'm having cache problems since versions 6.0.x were released.

When I run it directly as an Excel formula, it all works well, but I prefer to use it in my VBA macros, so I can work with the information I find. I use it like this, inside loops:

temp = Application.Run("IsFoundOnPage", Cells(i, xWebsite), arrayKeywords(x), 1)

The new versions of the plugin work fast, but won't wait for the cache to load, returning errors to the temporary variable, which I treat to become an empty cell. If I run the same macro a second time, it will return more values, so I have to keep running it like 10 times in a row to get all the results - and still, I won't be sure.

When I use version 5.1.4, it takes much longer to run, but I get all the results.

I've had similar issues when running "RegexpFindOnUrl".

So I have been using the older versions, as they are more trustworthy when used in VBA macros.

Anyone else having this issue? Any way to avoid it?

Thanks! (=

Hi Gustavo,

We have fixed this for the upcoming release. In the meantime, you can try the latest beta:
https://links.seotoolsforexcel.com/latestbeta

Here is a guide for disabling async:
https://seotoolsforexcel.com/working-with-vba/

Hey, Gustavo.

I also use VBA to automate my SeoTools projects and I'm happy to report that v6.1.2 (Beta) fixed this same problem for me. You can read my original post here:

Niels & Victor provided an excellent solution with their latest beta and all my scripts now work as designed. Good luck to you as well!

Thanks, guys! I'll try the new beta and disable asyc. Much appreciated!