1. M

    VBA Accessing GZIP JSON Response - Characters are garbled

    I am trying to access an api from a site called 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 = " 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 ( ), 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...

Some videos you may like

This Week's Hot Topics