sarahb1 / JSONtoCSV

This contains two files, first is a java .jar file which is made up of the BeanToCsv.class, Reader.class and org.JSON library (which can be found here: https://github.com/douglascrockford/JSON-java.git ). Compile these into a JAR file. The JAR file parses JSON (it has error handling that will default to my Facebook API rest url if you don't give it an input parameter). The .bat batch file should be saved in the same folder as the .jar and your excel file. The .bat file outputs the parsed json array into a .csv file, which can be opened with excel. To use this with VBA, use the shell() function to call the batch file (the batch file calls the .jar file and outputs the result). Example: Shell(toCsv.bat "json rest url"). Make sure within vba to also set your directory (before you call shell()), which can be done by writing the following: ChDir ThisWorkbook.path . Please cite Micah Fulton if you plan to use this source code.