Get - Last saved user - Excel

[JosephJohn]

How to get the last saved user from an Excel Sheet? Is there a way that BP can extract this value? The Utility File management - gives all the details except this. Any ideas are welcome! Thanks,

[John__Carter]

BP uses the Excel VBA API, so you need to first research how a macro would do it. Then it's a case of transcribing the macro code into VB.Net.

[JosephJohn]

Thanks for that tip, John. With a macro , Yes, i would be able to get the last user with something like : Function LastAuthor() LastAuthor = ActiveWorkbook.BuiltinDocumentProperties(""Last Author"") End Function I would have to then have the macro for each excel sheet to use it. But since I have a dynamically generated excel file without the macro enabled in it, and there will be thousands of different csv/Excel files to work on, we cannot create the macro for each of the files. So the question would be, if it was a text file(instead of Excel), how would i get the last saved user each time? Thanks