json

  1. S

    Parse JSON into Excel

    Hi I have been using the Jsonconverter vba parser available via https://github.com/VBA-tools/VBA-JSON to extract the data from json files such as https://stats.europeantour.com/v1/season/2019/players/strokes-gained/off-the-tee. This has been very easy to set up and it works. However, the...
  2. S

    Spaces don't look like spaces?

    Hello, I am putting together a string, and using the print statement to output to a file. I have an equation in the cell that I want to print out. The equation results in a string. That string has general characters, and spaces in it, and looks fine in excel. I use the following to print to...
  3. P

    How to Clear a JSON file

    Does anybody know what the command is to reset / clear / refresh a JSON file before the file is loaded with another set of data? Thanks. :)
  4. P

    JSON file within VB

    Hello. I am loading up a JSON file with particular data and dumping it out to Excel. The process works, but when I try and grab the next set of data, I get an error. I am assuming the JSON file needs to be cleared/emptied so that the next 50 rows of data can be loaded. Does anybody have a...
  5. W

    Above my ability level :-( (JSON Parsing/ Editing with VBA)-- I have attached my attempt

    Hello All! Hope you can help because I think I'm in on more than I can handle on this one. I have linked 2 files. One is titled "xepg.json" and one titled "JSONCHANNELNUMBEREDIT.xlsm". My goal is to get a json file imported to excel as a table (columns and rows) that can be easily edited and...
  6. S

    Unable to parse JSON data in Excel.

    I'm having some trouble with parsing JSON data in VBA. I have tried all of the examples online but I'm still unable to solve the issue. What I have managed to do is pull the JSON data into excel in the original format using another VBA code that pulled in data from another website. I've...
  7. J

    VBA - How to convert JSON to Table ?

    Hi, i have the following which loads a webpage and extracts the JSON Sub JSON1() Dim username As String, password As String username = "xxx" password = "xxx" Dim xmlhttp As Object, myurl As String Set xmlhttp = CreateObject("MSXML2.serverXMLHTTP") myurl = Range("C1")...
  8. J

    MSXML2.serverXMLHTTP : Adding Authentication + getting JSON

    Hi, i am experimenting with the following: Sub testXMLHTTP_VBA()Dim xmlhttp As Object, myurl As String Set xmlhttp = CreateObject("MSXML2.serverXMLHTTP") myurl = "https://www.mrexcel.com/forum/excel-questions/" xmlhttp.Open "GET", myurl, False xmlhttp.Send MsgBox (xmlhttp.responseText) End...
  9. S

    Custom Theme

    Hi, I am have a Line and stacked column chart Visual with formatting. (Show Data labels for CUSTOMIZE SERIES etc). I need a JSON Theme file for using with other similar visuals. Sample file is available in the link https://drive.google.com/open?id=1UmilRTUm_LGfv-tRoIXyyVpv3mLTOPtV Request...
  10. J

    ie.Navigate save file to folder?

    Hi, I managed to login to site then navigate to specific URL which is a JSON After loading the page, a prompt comes up to open/save JSON Is there a way I can save this to a specific folder with VBA?
  11. B

    External data from dynamic URL?

    Hi everyone! I've been trying to establish a data connection to an online JSON file. This seems to work just fine, but part of the URL is a date, like so: https://www.sampleurl.com/api/file.json?id=25&start=2019-01-01&limit=2500 I'd like to be able to have that date automatically be today's...
  12. O

    Using VBA to convert JSON, with multi-level dictionaries

    Hi All, I am trying to use the NVD database JSON files (available to download from https://nvd.nist.gov/vuln/data-feeds - ) so I can construct a sheet of all the vulnerailities and then I can sort them in Excel. Yes, I realise that NVD does offer a search function so I could limit it to Oracle...
  13. Mrsbex

    VBA to obtain Dropbox folder location into Excel

    Hi All, I have a macro which worked beautifully on my PC to save a workbook to Dropbox. However, when a colleague tried to use it, it didn't work because Dropbox on their PC is not in the usual place. I have looked into obtaining the Dropbox directory from the json file but I don't know how to...
  14. N

    Outputting a JSON response to sheets.

    Hi, I am using VBA-Web to pull in some data in a json format via REST. Which works fine using Public Sub PullStaff()Dim Client As New WebClient Dim Request As New WebRequest Dim RequestResponse As WebResponse WebHelpers.EnableLogging = True Client.BaseUrl =...
  15. F

    VBA xml to json problem

    Hello, I have a problem with the MSXML2.XMLHTTP object in VBA. I need to send a message in json but the auth token has double quotes in it. So in order for those double quotes to arrive in the message a backslash is used. Now by parsing the xml to Json the xmlhttp object adds an extra...
  16. M

    API Help

    I have established an API question via Power Query and I am just mimic it through VBA. The JSON document that is returned has multiple drill downs that I need; however, I had to create a new connection each time to change the let statements. I think this is where my query is going really slow...
  17. I

    Excel sheets parsing in to JSON using VBA Macro

    Hi, Need to parse a excel sheet containing multiple sheets in it in to a JSON using VBA Macro. And during JSON conversion below should be achieved. 1. The file has multiple sheets. 2. Create a Macro button in a new sheet and call it as Refresh JSON. 3. On click of the above...
  18. B

    VBA http Post Request - Postman key/value/body provided

    Hi All, I have been working on this for days without success. Even downloaded VBA-WEB and looked at examples there, online and everywhere. I can't seem to get this figured out and I have been working with VBA code for 15 years. I am pretty new at API but Postman makes things pretty...
  19. B

    Pick out some details in a JSON file and print these in a text file

    Hi I have since 1999 downloaded statistics in XML format from a home page and now they have changed to JSON. I can't write code myself and wondering if anyone can help me with VBA code that can pick out details from this file and print the details in a text file. I keep my fingers crossed that...
  20. J

    Can I import JSON data (API) into my Excel Online Sheet?

    Hi everyone, Hope you are well. I would like to import daily data from JSON via an API into my Excel Online sheet. It is very important that it is Excel Online because it is for collaboration purpose. If I am right, this is not possible. However, could I, as a first step, import Json into a...

Some videos you may like

This Week's Hot Topics

  • Importing multiple excel files into one spreadsheet
    Hi, I'm trying to import multiple excel files (with the same format into a single spreadsheet) so that each day's file is listed underneath the...
  • find many based on a certain criteria
    good evening, I hope someone can help me? I have a workbook sheet 2 contains lots of data.... I would like to be able to find anything on sheet...
  • How to copy multiple rows using If
    Hi all, I'm very new to VBA and have written this simple code to copy certain cells if a certain cell within that row contains any data. I need...
  • VBA If statement
    Dear All, I have two dates, where I'd like a message box to pop, if the dates are between this criteria. [CODE] sDate1 = #10/1/2019#...
  • Text Format
    I have a sheet for user to keyin the data. The format of the data can be 451 / 1903, 0012 / 9908 or 00287 / 0099. The number after the "/" is...
  • Syntax errors
    Good Morning, Trying to compile a workbook, I keep getting a few errors. Here are the first two: [code=rich]Syntax Error: Function...
Top