httprequest

  1. M

    VBA Accessing GZIP JSON Response - Characters are garbled

    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...
  2. B

    How can I pull data from a specific table with VBA on a webpage with lots of tables.

    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...
  3. Z

    Count Occurences of String in a Worksheet from MS Access

    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 =...
  4. A

    Excel VBA browser opening alot of pages from single link

    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 " &...
  5. U

    Issue with sending request to API

    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...
  6. A

    Recovering Suspended Tickets - Excel VBA

    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...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top