So currently I need to extract a certain set of files and check the data in them.
Essentially, I have a file with ID, First Name, Last Name and amount. I want to validate this data against other sheets. Right now, I’ve got a ‘File Path’ which is the file path and then ‘Files’ variable, which is new DirectoryInfo(FilePaths).GetFiles().OrderByDescending(Function(f) f.LastWriteTime).First().ToString. I was looking for some assistance to find whether this would read every file in the file path, or what should be next?
I was thinking that it would require a For Each File in Files and then read the files? I need and output each to a DT.
So then I need to look up against 2 data sets, to return whether they’ve already left/maternity and output this to excel. I also want for each file to be able to have the total count of each files ID and the total amount, how best would you suggest for doing this?
Apologies, I’m a bit new to this whole thing, so any help would be super helpful.