They may have been asked before but I can't find a specific thread that combats this problem.
I'm trying to dynamically import .json files as they are placed in a folder within an excel in order to track metrics. I can import a singular file just fine, format it and then add an additional column which generates a timestamp.
However, when I try to replicate this with a folder of .json files, the new files just add columns instead of rows?
What I want is for new files to be appended onto the bottom of the table like this: -
Any ideas how I could achieve this? If it helps my .json file is formatted like this: -
{"accountNumber":"76329873","category1":"redp","q1":"yes","q2":"no","q3":"yes","q4":"yes","q5":"yes"}
{"header":"value","header":value"}
The end goal is for this to be stored on a Sharepoint site and a bin folder to store all of the json files. So if any of you have any crafty VBA solutions I'd love to hear if they could incorporate a sharepoint folder over a static FSO folder. I'm working on this myself too so feel free to discuss even if you don't know the answer! just trying to get an idea of how it can be done.
I'm trying to dynamically import .json files as they are placed in a folder within an excel in order to track metrics. I can import a singular file just fine, format it and then add an additional column which generates a timestamp.
However, when I try to replicate this with a folder of .json files, the new files just add columns instead of rows?
What I want is for new files to be appended onto the bottom of the table like this: -
Any ideas how I could achieve this? If it helps my .json file is formatted like this: -
{"accountNumber":"76329873","category1":"redp","q1":"yes","q2":"no","q3":"yes","q4":"yes","q5":"yes"}
{"header":"value","header":value"}
The end goal is for this to be stored on a Sharepoint site and a bin folder to store all of the json files. So if any of you have any crafty VBA solutions I'd love to hear if they could incorporate a sharepoint folder over a static FSO folder. I'm working on this myself too so feel free to discuss even if you don't know the answer! just trying to get an idea of how it can be done.