Hi Bob

If one is only interested in the user of the Excel application being
run, are there any merits of
Environ("UserName") over
application.username

I have only ever used the latter, but by chance happened to come across
the use of Environ variables elsewhere whilst researching something
today. I have no idea of the differences.


--
Regards

Roger Govier


"Bob Phillips" wrote in message
...
Just use

Environ("UserName")

to get the network login name.

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"R. Choate" wrote in message
...
Can I initialize the % sign as a variable in code to identify and use
to
indicate the user id of the user who is running the code on
their station? For example X = %. or something like that.

Thanks,
--
RMC,CPA