Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
User Name / Computer Name
Hi
I would like to setup a macro within Excel that checks who / which computer is using a particular Excel Doc. I know of the Excel VBA command: Application.UserName However this only seems to get the user name for the Excel application. Is there a command that gets the computer's "name" ? I use Excel 2003, and I am trying to find a way of limiting the use of a particular Excel Doc to certain users. These users may find it is easy to change the Excel user name, however they are unable to change their computer's name. Many thanks for your input and comments David Hall |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
User Name / Computer Name
Hi David
See http://www.erlandsendata.no/english/index.php?t=envbaos on this HTH. best wishes Harald "David Hall" skrev i melding ... Hi I would like to setup a macro within Excel that checks who / which computer is using a particular Excel Doc. I know of the Excel VBA command: Application.UserName However this only seems to get the user name for the Excel application. Is there a command that gets the computer's "name" ? I use Excel 2003, and I am trying to find a way of limiting the use of a particular Excel Doc to certain users. These users may find it is easy to change the Excel user name, however they are unable to change their computer's name. Many thanks for your input and comments David Hall |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
User Name / Computer Name
Grüezi David
David Hall schrieb am 28.05.2004 I would like to setup a macro within Excel that checks who / which computer is using a particular Excel Doc. I know of the Excel VBA command: Application.UserName However this only seems to get the user name for the Excel application. Is there a command that gets the computer's "name" ? Try the following: Environ("Username") Environ("Computername") -- Regards Thomas Ramel - MVP for Microsoft-Excel - [Win XP Pro SP-1 / xl2000 SP-3] |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
User Name / Computer Name
Harald
Many thanks for this - brilliant -----Original Message----- Hi David See http://www.erlandsendata.no/english/index.php? t=envbaos on this HTH. best wishes Harald "David Hall" skrev i melding ... Hi I would like to setup a macro within Excel that checks who / which computer is using a particular Excel Doc. I know of the Excel VBA command: Application.UserName However this only seems to get the user name for the Excel application. Is there a command that gets the computer's "name" ? I use Excel 2003, and I am trying to find a way of limiting the use of a particular Excel Doc to certain users. These users may find it is easy to change the Excel user name, however they are unable to change their computer's name. Many thanks for your input and comments David Hall . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula only working for 1 user on 1 computer | Excel Discussion (Misc queries) | |||
Formulaed cell response varies from computer to computer | Excel Discussion (Misc queries) | |||
User defined buttons in Toolbars,transfer to another computer | Excel Discussion (Misc queries) | |||
How can I ensure a message to the computer user is aknowledged? | Excel Programming | |||
_How could I get the code to find out the resolution that user has in the computer | Excel Programming |