Get Excel user's name 13

[pho01]

How do I get the username's of the Excel application using VBA?

To be more clear, that's the username when one brings up Excel application, "this product is licensed to ...(username)".

Thanks,

 

[strongm]

environment variables are not fixed, and can easily be changed by the user.

 

[xlbo]

strongm - if you don't mind.....could you provide further info...how exactly could a user change the environ("username&quot for example ???

Rgds, Geoff
[blue]Si hoc signum legere potes, operis boni in rebus Latinus alacribus et fructuosis potiri potes![/blue]
Want the [red]best[/red] answers to your questions ? faq222-2244

 

[strongm]

Here's one way

My Computer/Properties/Advanced/Environment Variables

Then click New if username isn't listed (it's a built-in variable, but can be overridden)

Type "Username" against variable name
Type "whateveryoulike" against "Variable Value"

OK/OK/OK

 

[xlbo]

Thanks Strongm - given the computer literacy of most of the users here.....and the fact that most machines are locked down, I'll take my chances with the environment variables. Would this cause a similar problem with the api call as supplied by Chattin ??

Rgds, Geoff
[blue]Si hoc signum legere potes, operis boni in rebus Latinus alacribus et fructuosis potiri potes![/blue]
Want the [red]best[/red] answers to your questions ? faq222-2244

 

[VBAjedi]

What OS are you using, strongm? I don't have the "Advanced" tab in Properties. . .


VBAjedi

 

[strongm]

xlbo,
No, it doesn't effect the API solution

VBAjedi,
NT-based have it: Nt4, W2K, XP, 2003

In W95/98/Me it's easier: start a commandline and type: set username=whateveryoulike

 

[mscallisto]

Or throw it in your autoexec.bat or any .bat for that matter

 

[mscallisto]

Sorry I didn't finish....

Placing all the "sets" in one place makes them easier to deal with later