How to I open the latest created excel file in a folder which the folder is in another folder

Help Studio
, ,
3

Hi @RPA_Innovation ,

  1. Use a for loop to loop through the folders by giving the main folder as Input.
  2. Inside the for loop use the following expresssion Directory.GetFiles().OrderByDescending(function(s) System.IO.file.GetCreationTime(s)).First() to get the latest file. Path will be the for loop item (which is the folder path of each of 12 folders inside main folder)

cheers