Please help in creating routine / first consultation on the forum

Help Studio
, ,
1

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.

2

Hi @Javier_Sanchez

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

expression:

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

image
image1122×736 43.7 KB

You can also include subfolders

2 Likes
4

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
5

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