Getting Username from a file

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.

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

see other thread

--
HTH

Bob Phillips

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

<[email protected]> wrote in message
news:[email protected]...
> 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
>