Thread: UserName
View Single Post
  #10   Report Post  
Posted to microsoft.public.excel.programming
Myriam Myriam is offline
external usenet poster
 
Posts: 97
Default UserName

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.