How can Get file "Last saved by"

[cynbol]

In the shared folder,have lots of type files
I want to use"IO.FILE" to get"Last saved by" ,but only have "onwer "
how can i get the file “Last saved by”
help me please~

[lrtetala (Lakshman Reddy)]

Hi @cynbol

Please check this

How to get excel last saved by file details in uipath studio

Hi everyone I got the solution. Here is the link of the youtube video [Extracting Excel Properties with UiPath Using VBA Script | Automate with Ambika] Thanks, Ambika

How to get "Last saved by" of a file

@pondyondaime, Okay, then try with the below query, it will give you the username of the last modified file in a directory Directory.GetFiles("yourDirectoryPath").[Select](Function(f) New FileInfo(f)).OrderByDescending(Function(fi) fi.LastWriteTime).First.GetAccessControl().GetOwner(GetType(System.Security.Principal.NTAccount)).ToString()

Regards,

[Ajay_Mishra (Ajay Mahendra Mishra)]

@cynbol using Drive, Sharepoint or anything like that?

Regards,
Ajay Mishra

[cynbol]

i tried this but only type into the folder can’t typeinto the file full path

[cynbol]

No, it’s just that other servers are mapped to local folders

[Ajay_Mishra (Ajay Mahendra Mishra)]

@cynbol

No, it’s just that other servers are mapped to local folders

Okay!

@cynbol

i tried this but only type into the folder can’t typeinto the file full path

@cynbol Just elaborate more on this with screenshot if possible.

Regards,
Ajay Mishra

[cynbol]

in this way，only typeinto the Folder path not a file full path

[Ajay_Mishra (Ajay Mahendra Mishra)]

@cynbol You are getting any error?

Regards,
Ajay Mishra