Forum Discussion

SteveCswc's avatar
SteveCswc
Copper Contributor
Jun 13, 2020

Help automating the import and processing of JSON files

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

Excel Desktop
Need Help

2 Replies

    • SteveCswc's avatar
      SteveCswc
      Copper Contributor
      Jun 13, 2020

      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.

Resources