The robot is not using the latest downloaded file from the folder, it is using the previously downloaded file.
for example : Two files are downloaded one at 10:13 AM and another one at 10:18 AM
the bot should use the same excel which is downloaded at 10:18 AM , i.e. it should use the latest and current downloaded file
in my case , the bot is using the excel file which is downloaded at 10:13 AM.
Requesting anyone’s help over here. the below code i’m using
io_str_Filepath = Directory.GetFiles(folderpath,“Out Of *.xlsx”).OrderByDescending(Function(d) New FileInfo(d).CreationTime).ToList(0)