How can I "capture" the the name of the last user that saved a wkbk? Is there
something like capturing date/time BuiltinDocumentProperties ("Last Save
Time") for user name?
Thanks. I'm really greatful for any light you can give me.

BuiltinDocumentProperties ("Author")


--

HTH

RP
(remove nothere from the email address if mailing direct)


"Myriam" wrote in message
...
How can I "capture" the the name of the last user that saved a wkbk? Is
there
something like capturing date/time BuiltinDocumentProperties ("Last Save
Time") for user name?
Thanks. I'm really greatful for any light you can give me.

Bob... Would it be Author or Last Author? I don't use this that much so if
you could illuminate the situation.

"Bob Phillips" wrote:

BuiltinDocumentProperties ("Author")


--

HTH

RP
(remove nothere from the email address if mailing direct)


"Myriam" wrote in message
...
How can I "capture" the the name of the last user that saved a wkbk? Is
there
something like capturing date/time BuiltinDocumentProperties ("Last Save
Time") for user name?
Thanks. I'm really greatful for any light you can give me.

Thanks, Bob and Jim for your replies. However, "Author" or "Last Author"
gives me the computer name not the User (login name). Any other ideas?
Regards,

"Jim Thomlinson" wrote:

Bob... Would it be Author or Last Author? I don't use this that much so if
you could illuminate the situation.

"Bob Phillips" wrote:

BuiltinDocumentProperties ("Author")


--

HTH

RP
(remove nothere from the email address if mailing direct)


"Myriam" wrote in message
...
How can I "capture" the the name of the last user that saved a wkbk? Is
there
something like capturing date/time BuiltinDocumentProperties ("Last Save
Time") for user name?
Thanks. I'm really greatful for any light you can give me.

Jim,

Author is the creator, Last Author is the latest updater. Correctly you
surmise that it should be Last Author.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Jim Thomlinson" wrote in message
...
Bob... Would it be Author or Last Author? I don't use this that much so if
you could illuminate the situation.

"Bob Phillips" wrote:

BuiltinDocumentProperties ("Author")


--

HTH

RP
(remove nothere from the email address if mailing direct)


"Myriam" wrote in message
...
How can I "capture" the the name of the last user that saved a wkbk?
Is
there
something like capturing date/time BuiltinDocumentProperties ("Last
Save
Time") for user name?
Thanks. I'm really greatful for any light you can give me.

For the files you are trying to determine the last saved by name, when you
click on File - Properties - Statistics what do you see in the last saved
by?

"Myriam" wrote:

Thanks, Bob and Jim for your replies. However, "Author" or "Last Author"
gives me the computer name not the User (login name). Any other ideas?
Regards,

"Jim Thomlinson" wrote:

Bob... Would it be Author or Last Author? I don't use this that much so if
you could illuminate the situation.

"Bob Phillips" wrote:

BuiltinDocumentProperties ("Author")


--

HTH

RP
(remove nothere from the email address if mailing direct)


"Myriam" wrote in message
...
How can I "capture" the the name of the last user that saved a wkbk? Is
there
something like capturing date/time BuiltinDocumentProperties ("Last Save
Time") for user name?
Thanks. I'm really greatful for any light you can give me.

I see the name of the terminal I am using (in this case my name). When I log
in with a different user name, it again shows my name.

"Jim Thomlinson" wrote:

For the files you are trying to determine the last saved by name, when you
click on File - Properties - Statistics what do you see in the last saved
by?

"Myriam" wrote:

Thanks, Bob and Jim for your replies. However, "Author" or "Last Author"
gives me the computer name not the User (login name). Any other ideas?
Regards,

"Jim Thomlinson" wrote:

Bob... Would it be Author or Last Author? I don't use this that much so if
you could illuminate the situation.

"Bob Phillips" wrote:

BuiltinDocumentProperties ("Author")


--

HTH

RP
(remove nothere from the email address if mailing direct)


"Myriam" wrote in message
...
How can I "capture" the the name of the last user that saved a wkbk? Is
there
something like capturing date/time BuiltinDocumentProperties ("Last Save
Time") for user name?
Thanks. I'm really greatful for any light you can give me.

That must be because you have the computer name setup as the Excel user
(ToolsOptionsGeneral).

There is an MS DLL which can access properties without opening the WB.
Haven't used it myself, but if you want to play, you can find it at
http://support.microsoft.com/s*uppor...Q224/3/51.A*SP
FILE: DSOFILE.EXE Lets You Read Document Properties w/o Office Installed


--

HTH

RP
(remove nothere from the email address if mailing direct)


"Myriam" wrote in message
...
Thanks, Bob and Jim for your replies. However, "Author" or "Last Author"
gives me the computer name not the User (login name). Any other ideas?
Regards,

"Jim Thomlinson" wrote:

Bob... Would it be Author or Last Author? I don't use this that much so
if
you could illuminate the situation.

"Bob Phillips" wrote:

BuiltinDocumentProperties ("Author")


--

HTH

RP
(remove nothere from the email address if mailing direct)


"Myriam" wrote in message
...
How can I "capture" the the name of the last user that saved a wkbk?
Is
there
something like capturing date/time BuiltinDocumentProperties ("Last
Save
Time") for user name?
Thanks. I'm really greatful for any light you can give me.

A Mistake? What is that for you... Once now... ;-)

"Bob Phillips" wrote:

Jim,

Author is the creator, Last Author is the latest updater. Correctly you
surmise that it should be Last Author.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Jim Thomlinson" wrote in message
...
Bob... Would it be Author or Last Author? I don't use this that much so if
you could illuminate the situation.

"Bob Phillips" wrote:

BuiltinDocumentProperties ("Author")


--

HTH

RP
(remove nothere from the email address if mailing direct)


"Myriam" wrote in message
...
How can I "capture" the the name of the last user that saved a wkbk?
Is
there
something like capturing date/time BuiltinDocumentProperties ("Last
Save
Time") for user name?
Thanks. I'm really greatful for any light you can give me.

Thank you sooo much! to you both. I was going nuts! Its perfect.
Regards,


"Bob Phillips" wrote:

That must be because you have the computer name setup as the Excel user
(ToolsOptionsGeneral).

There is an MS DLL which can access properties without opening the WB.
Haven't used it myself, but if you want to play, you can find it at
http://support.microsoft.com/sÂ*uppo...224/3/51.AÂ*SP
FILE: DSOFILE.EXE Lets You Read Document Properties w/o Office Installed


--

HTH

RP
(remove nothere from the email address if mailing direct)


"Myriam" wrote in message
...
Thanks, Bob and Jim for your replies. However, "Author" or "Last Author"
gives me the computer name not the User (login name). Any other ideas?
Regards,

"Jim Thomlinson" wrote:

Bob... Would it be Author or Last Author? I don't use this that much so
if
you could illuminate the situation.

"Bob Phillips" wrote:

BuiltinDocumentProperties ("Author")


--

HTH

RP
(remove nothere from the email address if mailing direct)


"Myriam" wrote in message
...
How can I "capture" the the name of the last user that saved a wkbk?
Is
there
something like capturing date/time BuiltinDocumentProperties ("Last
Save
Time") for user name?
Thanks. I'm really greatful for any light you can give me.

"Jim Thomlinson" wrote in message
...
A Mistake? What is that for you... Once now... ;-)

I wish it was just once <vbg

You already have a load of info here, but I just thought I'd throw in
something I use. I added a "Before_Save" event to my files and have it write
the following to a "very hidden" sheet in the file (you could also code this
to update a remote text file for user history) [NOTE: ReturnComputerName also
returns the computer name that the user was on when they saved the file]:

Public Function ReturnUserName() As String
'RETURN THE USER NAME AS RECORDED IN [TOOLS][OPTIONS][GENERAL]
ReturnUserName = Application.UserName
End Function

OR:

Public Function ReturnNetworkName() As String
'RETURNS NETWORK LOGIN ID OF CURRENT USER
ReturnNetworkName = Environ("UserName")
End Function

AND:

Public Function ReturnComputerName() As String
'RETURNS COMPUTER NUMBER USER IS ON
ReturnComputerName = Environ("ComputerName")
End Function

HTH

"Myriam" wrote:

How can I "capture" the the name of the last user that saved a wkbk? Is there
something like capturing date/time BuiltinDocumentProperties ("Last Save
Time") for user name?
Thanks. I'm really greatful for any light you can give me.

I dont know if this helps, but...

Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As
Boolean)
MsgBox Application.UserName
Dim wsnet
Set wsnet = CreateObject("wscript.network")
MsgBox wsnet.UserName
Set wsnet = Nothing
End Sub

application.username = username listed in Excel
The other code will pull the network login name. You can save it to a
variable (i.e., varname = wsnet.username), and you could use the Now()
option to stamp the date and time. Then you could either record the
information on a worksheet or in a text file.

Brian



"Myriam" wrote in message
...
How can I "capture" the the name of the last user that saved a wkbk? Is
there
something like capturing date/time BuiltinDocumentProperties ("Last Save
Time") for user name?
Thanks. I'm really greatful for any light you can give me.