Help automating the import and processing of JSON files

[SteveCswc]

I currently receive a large number of JSON files and I need to import them into excel and process the data. Each JSON file has 3 tables to import, expand and save. Each of the JSON files has a different filename and contains similar data but slightly different field names (for example one file might have March data, the next will have April data, etc.). I tried recording a macro but the macro then wants to process the specific file that was already processed with the specific fieldnames. It seems that I can not make it 'generic' enough to process one month of data then the next month. Can anyone help?

Thanks,

Steve

[#2]

Hello,

You can watch the video in the link below on how to import Jason files into excel using Power Query

https://youtube.com/watch?v=CjnsX81qWUg

[#3]

@Abiola1 

Thanks, yes, I have watched that video and it is very informative; however, I am trying to automate that process so I don't have to go through the manual steps for every for every table within every file. So I want to do everything he did but in a 'macro' or VBA process.

Again, thanks for the response.