Exception from HRESULT:0x800A03EC


#1

Attempting to use the Google Search Console Connector and am getting this error when I attempt to insert the formula:

Exception from HRESULT:0x800A03EC

if I just insert values, things are fine. Inserting a formula results in the above error. Here’s the formula I’m trying to use (where xxxxx is my domain):

=Connector("GoogleSearchConsole.SearchAnalytics","https://xxxxx.org/","2018-09-30","2018-10-05","country==USA","web",3000,0,"Page,Clicks",TRUE)

After flashing the exception, the reset of the column actually comes in and the cell holding the formula retains an error.

Restarting Excel didn’t help.

I re-installed the latest version of SEOTools as well (8.0.36).

Thoughts?


#2

Hi,

Not sure why you are getting this error. Have you tried using dump before the formula? Also, can you post a print screen of the "About" window to make sure your references are correct?


#3

I’m actually using the dump:

=Dump(Connector("GoogleSearchConsole.SearchAnalytics","https://xxxx.org/",CR3,CR3+6,"country==USA","web",3000,0,"Page,Clicks",TRUE))

Where CR3 is a date in the format: yyyy-mm-dd

temp


#4

I’m also seeing "Cannot perform runtime binding on a NULL reference."


#5

I’m running .net framework 4.7, BTW.

Yesterday I reinstalled SEOtools. When I clicked on "Manage" in order to redownload some connectors, I just got this error:

Object reference not set to an instance of an object.


#6

You know what, it must be a corrupted spreadsheet or something. The same formula in a blank, new sheet, works fine. So, I’ll rebuild my workbook and see what happens. :frowning:


#7

How did it work out with the new workbook? :slight_smile:


#8

The new workbook turned out to be just the trick!