alirezae90
New Member
- Joined
- Jan 20, 2019
- Messages
- 8
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.
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.