I am only trying to get the "ac_monthly" array.and will then be inserting those 12 values into individual cells in my sheet. Make sure, you have included a reference to 'Microsoft Scripting Runtime' via Tools-References. Browse to the JsonConverter.bas file and import it. Right click the VBA-project in Project Explorer and click Import File. This will return XML (or with a slight modification, JSON) data formatted as described here: Open Excel and the VBA-editor with your VBA-project. Once I get the data into my workbook, I can take it from there.I just need help getting data from a precomposed URL string. Click the New Query dropdown option and then From File and From Text. It is also OK if I need to set up each parameter as a reference to a cell rather than the URL string being precomposed. How to open JSON files in Excel Now, open the Excel file, either existing or new.
My URL can be formatted to return XML or JSON data if one format or the other gives me the capabilities I am looking for. I am certain there must be a way to do this.but I have not been able to find it. I have formatted the URL properly and have it in a cell that is named ApiUrl however when I try to set up a data source in Excel, it seems to always require me to provide the URL in the setup wizard rather than referencing data in my spreadsheet (such as this pre-formatted URL). I have an API call to make from my Excel spreadsheet that will have various parameters depending on the data entered in the spreadsheet.
0 kommentar(er)
