Making Game: Saving content of individual cells within a column as separate JSON files

Original Source Link

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.

Tagged : / /

Leave a Reply

Your email address will not be published. Required fields are marked *