Problem with Kucoin - Run-time error '-2147012746 (80072f76)' about crypto_vba HOT 2 CLOSED

Hi @Pi-Rr
I got the same error the first time I tried, apparently the variable "apikey" is empty when the macro reaches that point. That variable should get picked up here:
secretkey = Sht.Range("secretkey_kucoin").Value
Bizarrely, I checked the reference and the cell and it seemed to be okay. So I ran the macro again and it worked like a charm. I'll keep on testing, but it did seem some weird fluke. Could you try checking the cell reference and maybe debug.print to confirm that the variable is empty when that function is called?

from crypto_vba.

Hi krijnsent,
I managed to fixed the issue, it was not related to the code but to Kucoin (which make sense given it was working perfectly till recently). They changed some security settings with regard to the API and I had to connect on the platform and reactivate the API key. It's working like charm again, I will close the issue 👍
Thanks :)

from crypto_vba.