Word or Excel Last Modified by

Help
1

Hello Creators,

we can get the modified date and time from Word or Excel file .
As same can we get the name of the person who modified by the document??

Regards,
Srenivasan Kannan

2

Hi just sharing you can use macro for these if you want to get that value. @SrenivasanKanna

cheers :smiley:

Happy learning :smiley:

2 Likes
3

If you have the filepath to the file in a string, then you can use this code in an assign activity.

System.IO.File.GetAccessControl(filePath).GetOwner(GetType(System.Security.Principal.NTAccount)).ToString.Split("\"c).Last

Reason I used a split and Last was because it gives you the user with the domain.

Regards.

3 Likes
4

@ClaytonM
I am grateful for your help.I appreciate your time! :heart_eyes:

2 Likes
5

@ClaytonM

the solution of *** System.IO.File.GetAccessControl(filePath).GetOwner(GetType(System.Security.Principal.NTAccount)).ToString

Its providing owner of the person name . Can we get the Last modified by person name.@Divyashreem Can you help me on this?

Regards,
Srenivasan Kannan

6

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