I am currently trying to merge two JSON files with VBA and then write them into a data set in Excel. This data set should then be able to be changed and then these changes should be applied. Afterwards everything should be written back into the two original files (Json) with all changes.
One of the JSON files ("user") is tabular and would have to be correctly aggregated (restructured) before being read in order to combine the matching primary key in the other JSON file.
Can anyone help me here? Do I first have to loop into the JSON file ("user") to restructure it before the import?
Thanks a lot
hi there, i am expert in vba and in json processing, will process the two files in json, will restructure the first file before merging with second, ready to start now and will be online until done, thanks