Re: Formula for Excel User Name
- From: "paul" <paul.shepherd@xxxxxxxxxxxxxxxxxxxxxx>
- Date: Fri, 27 May 2005 03:01:02 -0700
sheesh guys i did say MIGHT help,in my limited eperiene the user name was
included in the =info(directory)......I stand corrected :(
--
paul
remove nospam for email addy!
"David McRitchie" wrote:
> 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.
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > > >
> > >
> > >
> > >
>
>
>
.
- References:
- Formula for Excel User Name
- From: Shelll
- Re: Formula for Excel User Name
- From: Bob Phillips
- Re: Formula for Excel User Name
- From: paul
- Re: Formula for Excel User Name
- From: Bob Phillips
- Re: Formula for Excel User Name
- From: paul
- Re: Formula for Excel User Name
- From: David McRitchie
- Formula for Excel User Name
- Prev by Date: RE: concatenate problem
- Next by Date: Re: Count values ...
- Previous by thread: Re: Formula for Excel User Name
- Next by thread: identify even numbers with a "1" and odd numbers with a "0"
- Index(es):
Relevant Pages
|
