httprequest

I am trying to access an api from a site called keepa.com. I create a Msxml2.ServerXMLHTTP object and am able to get a response but the text is just a jumbled mess. For example the some of the response looks like this : I have tried to use MSXML2.XMLHTTP instead but I get an error saying that...

Here is my current code: Sub Pull_URL_Data() Dim myURL As String: 'URL String myURL = "https://www.website.com Call pullDataSingleURL(myURL, Sheets("Sheet1")) End Sub Function pullDataSingleURL(URL As String, ws As...

Hi, I want to search occurences of string "zeeshan" in a range in MS Excel through VBA from MS Access button click. Below is my code ... I am getting compile error : "method or member not found". With this error below line gets selected wordCount =...

I am using the following lines Public Sub NavigateToURL(argURL As String) Const READYSTATE_COMPLETE As Integer = 4 Dim objIE As Object Set objIE = CreateObject("InternetExplorer.Application") Shell ("C:\Program Files (x86)\Google\Chrome\Application\chrome.exe -url " &...

Hello, I have a very small issue and I believe it is related to my poor knowledge of HTTP. I'm trying to send a simple specified timestamp request to the following API ( https://www.bitfinex.com/pages/api ), but I do not know how to do it.... I can retreieve any unauthenticated request that...

Hi All, We have an internal Excel tool that recovers suspended tickets using vba and WinHttp.WinHttpRequest.5.1 Following is the process that we follow: 1. - Read the tickets in the suspended queue (using a winhttp and .json url) 2. - fetch the json data for the suspended ticket (excel vba...