Re: Formula for Excel User Name

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Paul's suggestion for =INFO("directory")
might kind of work if each user keeps their own files on a network drive in
their own area, but chances are if a macro needs to check who is using a file that several
users are using he same file. However, after being challenged it might have
been wiser to check out the other solutions and see what they had to offer.

Also the use of =cell("filename") as supplied is pretty much useless for anything
including the pathname of the active workbook. See paragraphs in italics at the top of
http://www.mvps.org/dmcritchie/excel/pathname.htm
you need to include a reference cell address, and as Bob indicated it does not
answer this question.

Some information on obtaining the userid and related information can be found in
http://www.mvps.org/dmcritchie/excel/userid.htm
but the specific question has already been answered by three people earlier in the thread.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"paul" <paul.shepherd@xxxxxxxxxxxxxxxxxxxxxx> wrote in message news:C5FD9B74-07EE-423A-ACAC-B34EE88B8EC0@xxxxxxxxxxxxxxxx
> At my last place of work i had a printing problem with a spreadsheet on one
> of three computers which acessed a quote sheet over the network.I identified
> the user by name using one of those formulas and then made some if then
> statement sin my macro......
> --
> paul
> remove nospam for email addy!
>
>
>
> "Bob Phillips" wrote:
>
> > Would you care to enlighten me as to what this has to do with the question
> > :-)
> >
> > Bob
> >
> > "paul" <paul.shepherd@xxxxxxxxxxxxxxxxxxxxxx> wrote in message
> > news:76079974-3FB1-45E8-89BA-B491CC4620D9@xxxxxxxxxxxxxxxx
> > > =CELL("filename")
> > > =INFO("directory")
> > > might help.
> > >
> > > --
> > > paul
> > > remove nospam for email addy!
> > >
> > >
> > >
> > > "Bob Phillips" wrote:
> > >
> > > >
> > > > thisUser = Environ("Username")
> > > >
> > > > --
> > > > HTH
> > > >
> > > > Bob Phillips
> > > >
> > > > "Shelll" <Shelll@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> > > > news:97F70BE0-1E4D-498B-9CB3-DE4557DBF823@xxxxxxxxxxxxxxxx
> > > > > Hi
> > > > >
> > > > > I was just wondering if there was a formula to get the Excel User Name
> > to
> > > > > print.
> > > > >
> > > > > I have a document that many users over a network use. At the moment
> > there
> > > > > is a cell in the document that automatically enters todays date but I
> > > > > wondered if there was a way to automatically enter the user as well.
> > I
> > > > have
> > > > > tried =Username() but this was just wishful thinking.
> > > > >
> > > > > Any help would be appreciated. Thanks.
> > > > >
> > > > >
> > > >
> > > >
> > > >
> >
> >
> >


.

Relevant Pages

  • Re: Formula for Excel User Name
    ... > Some information on obtaining the userid and related information can be found in ... >> remove nospam for email addy! ...
    (microsoft.public.excel.worksheet.functions)
  • RE: Drop down lists
    ... see my email address above,remove the nospam infront of paradise ... > Hi Paul ... > to see if you would send me the sample sheets but the message was returned as ... >> remove nospam for email addy! ...
    (microsoft.public.excel.misc)
  • Re: pricing problems
    ... >> remove nospam for email addy! ... >>> we have pricing sheets for, so that when we select a specific product it ...
    (microsoft.public.excel.worksheet.functions)
  • RE: How can I find automatic links in an Excel-sheet?
    ... >> next time you go into the sheet and you get the message go to the edit menu ... >> remove nospam for email addy! ...
    (microsoft.public.excel.misc)
  • Re: OT Bath remodel
    ... your email addy shows up without any "nospam" in it. ... used to send cash for each survey (I think they now use the same kind of ...
    (sci.med.transcription)