search

krijnsent / crypto_vba

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

Amazing Work - Question on error #58

Closed MasterSolutionsLLC closed 3 years ago

MasterSolutionsLLC commented 4 years ago

This is a remarkable piece of work and extremely generous to share it! Im very unlearned in json/api stuff, but am a long time Access/Excel solution person.

If I could bother you to figure out how to point me in the right direction> Im assuming this is a problem on my end, but Im not sure how to fix it. I try the coinbase pro with the sandbox api path, and I get this result. I have to comment out the last line in this or it doesnt work at all.

Im running Excel 2010 on Win 7, and perhaps that is a problem?

'DEFAULT: WinHttp.WinHttpRequest.5.1 Set objHTTP = CreateObject("WinHttp.WinHttpRequest.5.1") 'HTTP options, can be outcommented if needed 'WinHttpRequestOption_SslErrorIgnoreFlags - 13056: ignore all err, 0: accept no err objHTTP.Option(4) = 13056 'WinHttpRequestOption_SecureProtocols - 512 = TLS 1.1, 2048 for TLS 1.2 'objHTTP.Option(9) = 2048

{"error_nr":-2147483638,"error_txt":"The data necessary to complete this operation is not yet available. ","response_txt":0}

Any help you can provide to point me towards working this I would be grateful.

krijnsent commented 4 years ago

Did you check out #56 and #49 ? Both have that same error message, you could try Set objHTTP = CreateObject("MSXML2.XMLHTTP") in ModWeb. Does that work?

MasterSolutionsLLC commented 4 years ago

I did. It gives me this error. BTW... Im trying this on the sandbox site

.2 different machines. 1 is excel 2010 and Wn 7, the other is Excel 365 and Win 10.

crypto_vba {"error_nr":401,"error_txt":"HTTP-Unauthorized","response_txt":{"message":"Unauthorized."}}

On Fri, Aug 21, 2020 at 12:14 PM Koen Rijnsent notifications@github.com wrote:

Did you check out #56 https://github.com/krijnsent/crypto_vba/issues/56 and #49 https://github.com/krijnsent/crypto_vba/issues/49 ? Both have that same error message, you could try Set objHTTP = CreateObject("MSXML2.XMLHTTP") in ModWeb. Does that work?

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub https://github.com/krijnsent/crypto_vba/issues/58#issuecomment-678448945, or unsubscribe https://github.com/notifications/unsubscribe-auth/AQWCH6VSP3BCEOS7WHFIHS3SB3BSFANCNFSM4QG3FRDA .

--

Sean Henry Support Team Master Solutions *"Dont just manage your business, MASTER IT!"*http://www.mastersolutions.com http://www.mastersolutions.com/

Please download and open the following application to share your desktop in our session. The phone conference information is in the bottom left of the application window.

Click Here For Support Link http://mastersolutions.com/MasterSupport.exe

Please note:

  1. All support contact MUST be sent to support@mastersolutions.com or mastersolutionssupport@gmail.com in order to be routed and given priority. Please check your contact information for us.

    1. All support sessions require the user to log in and dial the phone conference number unless instructed to do otherwise.

    2. All support sessions are billed starting at the time the support technician joins the meeting, and end when the technician finishes all notes and uploading of support files.

    3. All cancellations less than 24 hours in advance will be charged for 50% of the scheduled support session. Standard support sessions are typically 1 hour.

    4. All times are PST unless stated otherwise. It is the responsibility of the customer to calculate the appropriate starting time

krijnsent commented 3 years ago

Hi there, what is the status of this issue? Does it still happen?

MasterSolutionsLLC commented 3 years ago

No... I have a few variants of this VBA code running both in Access and Excel. It is WONDERFUL! I sent some xlm, and your work is worth EVERY BIT!!!!! It has helped me learn and understand json, and there are so many differences it has been a real serious effort.

krijnsent commented 3 years ago

Thanks! Happy to hear my code helped you!

Op do 11 feb. 2021 om 22:37 schreef MasterSolutionsLLC < notifications@github.com>:

No... I have a few variants of this VBA code running both in Access and Excel. It is WONDERFUL! I sent some xlm, and your work is worth EVERY BIT!!!!! It has helped me learn and understand json, and there are so many differences it has been a real serious effort.

— You are receiving this because you commented. Reply to this email directly, view it on GitHub https://github.com/krijnsent/crypto_vba/issues/58#issuecomment-777808257, or unsubscribe https://github.com/notifications/unsubscribe-auth/AFHWZ47LBQM7BAH742CA4P3S6REYTANCNFSM4QG3FRDA .

--

http://www.validvalue.com