Including Environ Username in Cell

S

swieduwi

I have searched the forum several way to resolve my issue and the onl
solutions were as follows:


PHP code
-------------------

Public Function UserName()
UserName = Environ("username")
'UserName = Computer("UserName")
End Function
MsgBox Environ(”username”)

Option Explicit
Function NetworkUserName() As String
Dim response
NetworkUserName = Environ("Username")
End Function

-------------------


Problem is that I get a #REF! and #NAME! instead of the user names
I am using Excel 2000 (I can not upgrade, Government PC) pus we need i
to support Excel 2000 - present versions.

thank
 
R

Roger Govier

Hi

I found this function on Google, which I have used successfully.
I'm sorry but I don't have the author's name to give proper
accreditation, but whoever it is, thanks - I have found it useful.

=Getname(2) entered in a cell will return the user name


Function GetName(Optional NameType As String) As String
'Formula should be entered as =GetName([param])
'
'For Name of Type Enter Text OR Enter #
'MS Office User Name "Office" 1 (or leave blank)
'Windows User Name "Windows" 2
'Computer Name "Computer" 3

'Force application to recalculate when necessary. If this
'function is only called from other VBA procedures, this
'section can be eliminated. (Req'd for cell use)
Application.Volatile

'Set value to Office if no parameter entered
If Len(NameType) = 0 Then NameType = "OFFICE"

'Identify parameter, assign result to GetName, and return
'error if invalid
Select Case UCase(NameType)
Case Is = "OFFICE", "1"
GetName = Application.UserName
Exit Function
Case Is = "WINDOWS", "2"
GetName = Environ("UserName")
Exit Function
Case Is = "COMPUTER", "3"
GetName = Environ("ComputerName")
Exit Function
Case Else
GetName = CVErr(xlErrValue)
End Select

End Function
 
S

swieduwi

the =Getname(2) did not work as well, I get the #NAME?
What am I doing wrong??????
 
R

Roger Govier

Hi
Where are you pasting the code?
It needs to be in a general module of the workbook you are using, not in
the Sheet code.
--
Regards

Roger Govier


Roger Govier said:
Hi

I found this function on Google, which I have used successfully.
I'm sorry but I don't have the author's name to give proper
accreditation, but whoever it is, thanks - I have found it useful.

=Getname(2) entered in a cell will return the user name


Function GetName(Optional NameType As String) As String
'Formula should be entered as =GetName([param])
'
'For Name of Type Enter Text OR Enter #
'MS Office User Name "Office" 1 (or leave blank)
'Windows User Name "Windows" 2
'Computer Name "Computer" 3

'Force application to recalculate when necessary. If this
'function is only called from other VBA procedures, this
'section can be eliminated. (Req'd for cell use)
Application.Volatile

'Set value to Office if no parameter entered
If Len(NameType) = 0 Then NameType = "OFFICE"

'Identify parameter, assign result to GetName, and return
'error if invalid
Select Case UCase(NameType)
Case Is = "OFFICE", "1"
GetName = Application.UserName
Exit Function
Case Is = "WINDOWS", "2"
GetName = Environ("UserName")
Exit Function
Case Is = "COMPUTER", "3"
GetName = Environ("ComputerName")
Exit Function
Case Else
GetName = CVErr(xlErrValue)
End Select

End Function

--
Regards

Roger Govier


"swieduwi" <[email protected]>
wrote in message
I have searched the forum several way to resolve my issue and the
only
solutions were as follows:


PHP code:
--------------------

Public Function UserName()
UserName = Environ("username")
'UserName = Computer("UserName")
End Function
MsgBox Environ("username")

Option Explicit
Function NetworkUserName() As String
Dim response
NetworkUserName = Environ("Username")
End Function

--------------------


Problem is that I get a #REF! and #NAME! instead of the user names
I am using Excel 2000 (I can not upgrade, Government PC) pus we need
it
to support Excel 2000 - present versions.

thanks


--
swieduwi
------------------------------------------------------------------------
swieduwi's Profile:
http://www.excelforum.com/member.php?action=getinfo&userid=21962
View this thread:
http://www.excelforum.com/showthread.php?threadid=507221
Click to expand...
Click to expand...
 
S

swieduwi

Roger said:
Hi
Where are you pasting the code?
It needs to be in a general module of the workbook you are using, not
in
the Sheet code.
Click to expand...
[/QUOTE]
Thanks for the reply...

Yes I placed it in the General section of my Workbook code area and it
looks like this:

PHP code:
--------------------

Public Function UserName()

Select Case UCase(NameType)
Case Is = "OFFICE", "1"
GetName = Application.UserName
Exit Function
Case Is = "WINDOWS", "2"
GetName = Environ("UserName")
Exit Function
Case Is = "COMPUTER", "3"
GetName = Environ("ComputerName")
Exit Function
Case Else
GetName = CVErr(xlErrValue)
End Select

End Function
 
C

Chip Pearson

The code needs to be in a regular code module, NOT the
ThisWorkbook module or a sheet module.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"swieduwi"
message
Thanks for the reply...

Yes I placed it in the General section of my Workbook code area
and it
looks like this:

PHP code:
--------------------

Public Function UserName()

Select Case UCase(NameType)
Case Is = "OFFICE", "1"
GetName = Application.UserName
Exit Function
Case Is = "WINDOWS", "2"
GetName = Environ("UserName")
Exit Function
Case Is = "COMPUTER", "3"
GetName = Environ("ComputerName")
Exit Function
Case Else
GetName = CVErr(xlErrValue)
End Select

End Function

--------------------

in the cell I reference "=username()" I get a #REF! in the Cell
if I reference "=GetName(2) i get a #NAME?


--
swieduwi
------------------------------------------------------------------------
swieduwi's Profile:
http://www.excelforum.com/member.php?action=getinfo&userid=21962
View this thread:
http://www.excelforum.com/showthread.php?threadid=507221
[/QUOTE]
 
C

Chip Pearson

Roger Govier said:
Function GetName(Optional NameType As String) As String
Click to expand...

This function should have a return type of Variant, not String,
since one possible return value is CVErr(xlErrValue). Also, the
NameType should be declared ByVal -- it is bad form to change
argument values in the calling procedure unless it is required by
design.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com





Roger Govier said:
Hi

I found this function on Google, which I have used
successfully.
I'm sorry but I don't have the author's name to give proper
accreditation, but whoever it is, thanks - I have found it
useful.

=Getname(2) entered in a cell will return the user name


Function GetName(Optional NameType As String) As String
'Formula should be entered as =GetName([param])
'
'For Name of Type Enter Text OR Enter #
'MS Office User Name "Office" 1 (or leave
blank)
'Windows User Name "Windows" 2
'Computer Name "Computer" 3

'Force application to recalculate when necessary. If this
'function is only called from other VBA procedures, this
'section can be eliminated. (Req'd for cell use)
Application.Volatile

'Set value to Office if no parameter entered
If Len(NameType) = 0 Then NameType = "OFFICE"

'Identify parameter, assign result to GetName, and return
'error if invalid
Select Case UCase(NameType)
Case Is = "OFFICE", "1"
GetName = Application.UserName
Exit Function
Case Is = "WINDOWS", "2"
GetName = Environ("UserName")
Exit Function
Case Is = "COMPUTER", "3"
GetName = Environ("ComputerName")
Exit Function
Case Else
GetName = CVErr(xlErrValue)
End Select

End Function

--
Regards

Roger Govier


"swieduwi"
in message
I have searched the forum several way to resolve my issue and
the only
solutions were as follows:


PHP code:
--------------------

Public Function UserName()
UserName = Environ("username")
'UserName = Computer("UserName")
End Function
MsgBox Environ("username")

Option Explicit
Function NetworkUserName() As String
Dim response
NetworkUserName = Environ("Username")
End Function

--------------------


Problem is that I get a #REF! and #NAME! instead of the user
names
I am using Excel 2000 (I can not upgrade, Government PC) pus
we need it
to support Excel 2000 - present versions.

thanks


--
swieduwi
------------------------------------------------------------------------
swieduwi's Profile:
http://www.excelforum.com/member.php?action=getinfo&userid=21962
View this thread:
http://www.excelforum.com/showthread.php?threadid=507221
Click to expand...
Click to expand...
 
R

Roger Govier

Hi Chip

Many thanks for pointing this out. My VBA skills are limited, but
growing through participation here.
As I said in my first response to the OP, I found the routine somewhere
through a search on the web, and don't know the author.
Thus far, it has worked OK for me, but I guess I've been lucky and not
hit the Err values you mention.
I will change the routine accordingly.

If I understand you correctly, this should be
Function GetName(Optional NameType ByVal) As Variant.
Is this correct?

--
Regards

Roger Govier


Chip Pearson said:
Roger Govier said:
Function GetName(Optional NameType As String) As String
Click to expand...

This function should have a return type of Variant, not String, since
one possible return value is CVErr(xlErrValue). Also, the NameType
should be declared ByVal -- it is bad form to change argument values
in the calling procedure unless it is required by design.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com





Roger Govier said:
Hi

I found this function on Google, which I have used successfully.
I'm sorry but I don't have the author's name to give proper
accreditation, but whoever it is, thanks - I have found it useful.

=Getname(2) entered in a cell will return the user name


Function GetName(Optional NameType As String) As String
'Formula should be entered as =GetName([param])
'
'For Name of Type Enter Text OR Enter #
'MS Office User Name "Office" 1 (or leave blank)
'Windows User Name "Windows" 2
'Computer Name "Computer" 3

'Force application to recalculate when necessary. If this
'function is only called from other VBA procedures, this
'section can be eliminated. (Req'd for cell use)
Application.Volatile

'Set value to Office if no parameter entered
If Len(NameType) = 0 Then NameType = "OFFICE"

'Identify parameter, assign result to GetName, and return
'error if invalid
Select Case UCase(NameType)
Case Is = "OFFICE", "1"
GetName = Application.UserName
Exit Function
Case Is = "WINDOWS", "2"
GetName = Environ("UserName")
Exit Function
Case Is = "COMPUTER", "3"
GetName = Environ("ComputerName")
Exit Function
Case Else
GetName = CVErr(xlErrValue)
End Select

End Function

--
Regards

Roger Govier


"swieduwi" <[email protected]>
wrote in message
I have searched the forum several way to resolve my issue and the
only
solutions were as follows:


PHP code:
--------------------

Public Function UserName()
UserName = Environ("username")
'UserName = Computer("UserName")
End Function
MsgBox Environ("username")

Option Explicit
Function NetworkUserName() As String
Dim response
NetworkUserName = Environ("Username")
End Function

--------------------


Problem is that I get a #REF! and #NAME! instead of the user names
I am using Excel 2000 (I can not upgrade, Government PC) pus we need
it
to support Excel 2000 - present versions.

thanks


--
swieduwi
------------------------------------------------------------------------
swieduwi's Profile:
http://www.excelforum.com/member.php?action=getinfo&userid=21962
View this thread:
http://www.excelforum.com/showthread.php?threadid=507221
Click to expand...
Click to expand...
Click to expand...
 
S

swieduwi

This works fine but I am trying to show the last person who saved the
file,
I need to track who changed the file last since is resides on a network
drive.

this shows who currently has the sheet open.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Displaying the User Name and in a Text or label box. Environ("username") 1
Start Macro when specific Cells are selected 6
Excel excel function 'username' 1
Auto_open and environ variable error cannot find library 2
Get info from first cell in row. 5
Multiple Cell References in GetPivotData 4
Mailing an excel range in the body of an e-mail 3
Benefits of using template in generated word document? 2

Top