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
