Windows 10: Using Access VBA to read JSON data

Discus and support Using Access VBA to read JSON data in Windows 10 Gaming to solve the problem; Hi,I'm using the following VBA subroutine to read JSON data from a website:Sub DistanceRetrieve Dim url As String, attempts As Integer, strResponse As... Discussion in 'Windows 10 Gaming' started by Said El Noshokaty, Aug 23, 2022.

  1. SAID EL NOSHOKATY
    Said El Noshokaty Win User

    Using Access VBA to read JSON data


    Hi,I'm using the following VBA subroutine to read JSON data from a website:Sub DistanceRetrieve Dim url As String, attempts As Integer, strResponse As String, strLatitude As String Dim WinHttpReq As Object, Json As Object url = "https://distances.dataloy.com/port/port?filter=portNameEQBERGEN" attempts = 3 Set WinHttpReq = CreateObject"MSXML2.XMLHTTP.6.0" On Error GoTo TryAgain TryAgain: attempts = attempts - 1 Err.Clear If attempts > 0 Then With WinHttpReq .Open "GET",

    :)
     
    Said El Noshokaty, Aug 23, 2022
    #1
  2. PHANBUEY
    phanbuey Win User
    phanbuey, Aug 23, 2022
    #2
  3. DAVEM121
    DaveM121 Win User
    JSON extension files

    Hi Lil_953

    Please explain this in more detail, do you have json files you want to open?

    A JSON file is a JavaScript Object Notation and does not contain file data like a document or image. It can contain plain text, which you can read using the Notepad app in Windows . .

    Where are you sourcing the json files?
     
    DaveM121, Aug 23, 2022
    #3
  4. DONDRE1992
    dondre1992 Win User

    Using Access VBA to read JSON data

    MCHBAR read access failed

    Hi everyone,


    Trying to install TechPowerUp GPU-Z v0.3.8 but i keep getting...MCHBAR read access failed, any suggestions???
     
    dondre1992, Aug 23, 2022
    #4
Thema:

Using Access VBA to read JSON data

Loading...

  1. Using Access VBA to read JSON data - Similar Threads - Using Access VBA

  2. Файл .Json

    in Windows 10 Network and Sharing
    Файл .Json: Здравствуйте такая проблема что случайно выбрал что файлы .Json открываются теперь в блокноте, как сделать так что бы у меня был выбор через что я хочу открыть этот файл?...

  3. Using conditional statement in a json

    in Windows 10 Gaming
    Using conditional statement in a json: I am attempting to do conditional statement inside a .json file. I am finding that when a condition is met, the other conditions are ignored. It will only look a the first condition in my file whether it be true or false. Not sure what I am doing wrong or if this is just how...

  4. Using conditional statement in a json

    in Windows 10 Software and Apps
    Using conditional statement in a json: I am attempting to do conditional statement inside a .json file. I am finding that when a condition is met, the other conditions are ignored. It will only look a the first condition in my file whether it be true or false. Not sure what I am doing wrong or if this is just how...

  5. Using Access VBA to read JSON data

    in Windows 10 Software and Apps
    Using Access VBA to read JSON data: Hi,I'm using the following VBA subroutine to read JSON data from a website:Sub DistanceRetrieve Dim url As String, attempts As Integer, strResponse As String, strLatitude As String Dim WinHttpReq As Object, Json As Object url =...

  6. JSON FILES

    in Windows 10 Software and Apps
    JSON FILES: Please help!I accidentally clicked my .json files to always open with windows media player. I want to reset it to where I have the "open as" option again. Can anyone please help?...

  7. Windows 10 Build/Revision Data in JSON

    in Windows 10 Installation and Upgrade
    Windows 10 Build/Revision Data in JSON: Is the data at the following link available in a consumable API or feed? It would be extremely helpful to be able to house in a database the data at the below link and have it automatically be kept up to date as new builds and revisions are released. I am ultimately...

  8. Microsoft Access VBA assistance for Here API

    in AntiVirus, Firewalls and System Security
    Microsoft Access VBA assistance for Here API: For years I used google maps to calculate travel time and distance for sales routes. Using MS Access database table for locations and a little form that a user could select addresses and number a route sequence. However, this data is not freely accessible anymore. I used to...

  9. Can't open the immediate window in ACCESS VBA

    in Windows 10 BSOD Crashes and Debugging
    Can't open the immediate window in ACCESS VBA: Recently I have been unable to open the immediate window or locals window or watch window when working in Access 365. I'm not sure if this happened after the most recent Windows/Office365 updates, but it is very recent. Any help available? Gordon...

  10. JSON FILES

    in Windows 10 Network and Sharing
    JSON FILES: Hey, so I accidentally made my .json files to always open it with notepad. Now, I don't know how to restore it in its original state. Anyone can help? Also, I want the .json file to be a white blank icon again and with the command "open with..." to pop up....