Convert Excel data to JSON format using VBA

JSON format data is widely popular when it comes to send and receive information between a web server and a client. I bumped into a situation where I needed to do the POST to my server and obviously the data format I needed was in JSON. So, I wrote this little Excel VBA macro to convert a given range into a JSON format.

Excel Macro to convert given range to JSON format

%d bloggers like this: