search

krijnsent / crypto_vba

An Excel/VBA project to communicate with various cryptocurrency exchanges APIs
MIT License
155 stars 54 forks source link

Binance connection problem #33

Closed sbralin closed 6 years ago

sbralin commented 6 years ago

I ran VBA ModExchBinance/Sub TestBinance() but I got error, pls, advice: {"error_nr":-2147012739,"error_txt":"VBA-WinHttp.WinHttpRequest ?????? ????????? ?????????? ??????? "}

krijnsent commented 6 years ago

Hi @sbralin, it looks like this error: #25 Could you check out the solutions there and see if they work for you?

sbralin commented 6 years ago

Thanks works fine, So, to enable WinHTTP to leverage TLS 1.2 (or 1.1) on Windows 7, I installed an optional windows update and added a registry key to set the default security protocol (in this case pointing to TLS 1.2). After this, I restarted my machine and the macro worked without any issues. https://support.microsoft.com/en-us/help/3140245/update-to-enable-tls-1-1-and-tls-1-2-as-a-default-secure-protocols-in

krijnsent commented 6 years ago

Cool! Happy to hear