How to identify operating system user in excel?

By default, I would like to populate a cell in a excel sheet with the
operating system user id, with the person who opened the excel file. Is
there a way to do this? I would appreciate any help. Thanks. Sarita.

Hi,
Check at the Environ Function
Environ("username") returns the name of the os user.
--
Regards,
Sébastien


"Sarita" wrote:

> By default, I would like to populate a cell in a excel sheet with the
> operating system user id, with the person who opened the excel file. Is
> there a way to do this? I would appreciate any help. Thanks. Sarita.

Hi Sarita,

Possibly:

With Sheets(1).Range("A1")
Range("A1").Value = Application.OperatingSystem
Range("A2").Value = Environ("Username")
End With


---
Regards,
Norman



"Sarita" <[email protected]> wrote in message
news:[email protected]...
> By default, I would like to populate a cell in a excel sheet with the
> operating system user id, with the person who opened the excel file. Is
> there a way to do this? I would appreciate any help. Thanks. Sarita.

It works. Thank you so much. -- Sarita.

"sebastienm" wrote:

> Hi,
> Check at the Environ Function
> Environ("username") returns the name of the os user.
> --
> Regards,
> Sébastien
>
>
> "Sarita" wrote:
>
> > By default, I would like to populate a cell in a excel sheet with the
> > operating system user id, with the person who opened the excel file. Is
> > there a way to do this? I would appreciate any help. Thanks. Sarita.

It works. Thank you so much. -- Sarita.

"Norman Jones" wrote:

> Hi Sarita,
>
> Possibly:
>
> With Sheets(1).Range("A1")
> Range("A1").Value = Application.OperatingSystem
> Range("A2").Value = Environ("Username")
> End With
>
>
> ---
> Regards,
> Norman
>
>
>
> "Sarita" <[email protected]> wrote in message
> news:[email protected]...
> > By default, I would like to populate a cell in a excel sheet with the
> > operating system user id, with the person who opened the excel file. Is
> > there a way to do this? I would appreciate any help. Thanks. Sarita.
>
>
>