Excel to JSON Conversion using VBA macro

[itpgm21]

Hi,

1. A Excel file has multiple sheets in it.
2. Need to Create a Macro button in a new sheet and call it as Refresh JSON.
3. On click of the above button, the following should be achieved.
a. Parse data in all sheets into JSON. The number of sheets and number of columns in each sheet might vary.
b. Write this into an output file as XYZIndex.json – Single out put file containing data from all sheets (Save the file in the same location as the excel.)
c. Note that Column A (Name) of every sheet has hyperlinked data. This should get parsed as "Name": "filename", "URL": "file complete address"

So how to write VBA macro to achieve this?

 

[John_w]

Duplicate of https://www.mrexcel.com/forum/excel-questions/1078562-excel-sheets-parsing-json-using-vba-macro.html

 

[Fluff]

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread.
Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).

Note that sometimes posts from new users require Moderator approval before you can see them on the public forums. When this happens, you should see a message to that effect when you try to post it.
Please be patient and do not attempt to post the question again.