Thread: Getting Username from a file
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips Bob Phillips is offline
external usenet poster
  
Posts: 10,593
Default Getting Username from a file
see other thread

--
HTH

Bob Phillips

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

wrote in message
oups.com...
I use

RunUser = Environ("username")

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


pikapika13 wrote:
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.


--
pikapika13
------------------------------------------------------------------------
pikapika13's Profile:
http://www.excelforum.com/member.php...o&userid=10892
View this thread:
http://www.excelforum.com/showthread...hreadid=561182



Reply With QuoteReply With Quote