Getting Username from a file

[pikapika13]

I wish to get the "last modified" and the user who modified a file.
This is what I have:

Sub GetAttributes()
LM = FileDateTime("C:\blAH BLAH BLAH.xls")
Range("A1") = LM
End Sub

Can someone help me with the username piece? Much appreciated

 

[erikrthorne]

I use

RunUser = Environ("username")

This will pull the username they use to sign into their laptop.

 

[Bob Phillips]

see other thread

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

I use

RunUser = Environ("username")

This will pull the username they use to sign into their laptop.