How to loop through Folder structure and get files

I have this folder Structure:
\serverName\ExternalData:
BPM
CRM
DDM

I want to go through these folders, 1st one: \serverName\ExternalData\BPM and get the latest file, process it (take two fields and put it in the list, I have a code for this)

Then go to the second folder: \serverName\ExternalData\CRM, get the latest file, process it (take two fields and put it in the list, a different list, I have a code for this as well)

Then do the same of the third folder(DDM folder)

Please help.

Hey there,

nice to meet you! :wave:

What did you try so far?

1 Like