Re: Getting Username from a file Part 2
- From: "erikrthorne@xxxxxxxxx" <erikrthorne@xxxxxxxxx>
- Date: 13 Jul 2006 11:53:12 -0700
Sorry, misunderstood your question... you are correct that will give
you the name of ther person currently using your application...it won't
pull the name of ther person on the file...I'll have to research a
little to do your scenario...sorry about that.
pikapika13 wrote:
I received the response below. After testing it out..I can't get the
username of a specific file in a folder. I only get the username of
myself.
*******************************
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
--
pikapika13
------------------------------------------------------------------------
pikapika13's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=10892
View this thread: http://www.excelforum.com/showthread.php?threadid=561189
.
- References:
- Getting Username from a file Part 2
- From: pikapika13
- Getting Username from a file Part 2
- Prev by Date: Data check
- Next by Date: RE: GetObject Error 429 - ActiveX control cannot create object
- Previous by thread: Re: Getting Username from a file Part 2
- Next by thread: HTMLElementCollection Dilemna
- Index(es):
Relevant Pages
|