This is a tricky one but I know someone would find it a piece of cake here.
Is there a way to create a collection of JSON Files in a folder based on the content of individual cells in a column in excel?
So basically, I have a spreadsheet with a column starting with cell B12 to B26. Each cell contains a JSON script. I want a VBA that would convert each of these cells into a separate JSON File and create a collection in a folder so I can run in Postman.
Note: Each cell contains a lengthy (40 lines within 1 cell) JSON Script.
excelerator.solutions/2017/08/24/… and stackoverflow.com/questions/56842122/…suggest ways of converting/exporting to JSON but my job is actually easier as I have no variables. All I want is to have VBA linked to a button, that would export contents of cells within a column to multiple JSON files in a folder.
Is there a way to create a collection of JSON Files in a folder based on the content of individual cells in a column in excel?
So basically, I have a spreadsheet with a column starting with cell B12 to B26. Each cell contains a JSON script. I want a VBA that would convert each of these cells into a separate JSON File and create a collection in a folder so I can run in Postman.
Note: Each cell contains a lengthy (40 lines within 1 cell) JSON Script.
excelerator.solutions/2017/08/24/… and stackoverflow.com/questions/56842122/…suggest ways of converting/exporting to JSON but my job is actually easier as I have no variables. All I want is to have VBA linked to a button, that would export contents of cells within a column to multiple JSON files in a folder.