BID ONLY IF YOU KNOW YOU CAN FIX THE ISSUE
We have an Excel sheet that sends a request to the server and gets the response back. When the call to the server is made with less data (2 rows), then Excel gives the result back. When a call is the server is made with 75 rows, it errors with 500-Internal Server Error.
I will supply excel sheet with all relevant details to the successful candidate.
Set objHTTP = CreateObject("WinHttp.WinHttpRequest.5.1")
URL = "Will give to successfull candidate"
[login to view URL] 0, 0, 0, 0
[login to view URL] "POST", URL, False
[login to view URL] "Connection", "Keep-Alive"
[login to view URL] "User-Agent", "Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0)"
[login to view URL] "Content-Type", "application/json"
[login to view URL] "CharSet", "charset=UTF-8"
[login to view URL] "Content-Length", Len(reqjson)
[login to view URL] (pRequest)
[login to view URL]
NOTE: When similar call is made using other application (not excel) is works with any error.
Fixed price: £10
I have years of experience in Ms access, Advance Excel, VBA, and other office integration development.