Please help in creating routine / first consultation on the forum

Good day everyone. I’m trying to create a routine that checks the files in a folder, identifies Excel files, and shows me the properties (path and creation date) in a Message Box. Please help. Thank you in advance.

Hi @Javier_Sanchez

you can use For each file in Folder activity like this:


"Diretory: "+CurrentFile.Folder + vbLf + "Created Date: "+ CurrentFile.CreatedDate + vbLf + "Full Path" +CurrentFile.FullName

You can also include subfolders


excelFiles = Directory.GetFiles(“YourFolderPath”, “*.xlsx”)

Use “For Each” Activity to Iterate Through Files
inside “For Each” Activity, Use “Assign” to Get File Properties:
filePath = item
creationDate = File.GetCreationTime(item).ToString()
Inside the message box
"File Path: " + filePath + Environment.NewLine + "Creation Date: " + creationDate

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.