Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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. |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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. |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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. |
#4
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi Sarita,
Possibly: With Sheets(1).Range("A1") Range("A1").Value = Application.OperatingSystem Range("A2").Value = Environ("Username") End With --- Regards, Norman "Sarita" wrote in message ... 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. |
#5
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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" wrote in message ... 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Using XP Operating System to Search for Numbers Values in Excel Files | Excel Discussion (Misc queries) | |||
operating system not configured to run excel | Excel Discussion (Misc queries) | |||
Find out Operating System | Excel Programming | |||
Operating system | Excel Programming | |||
Operating system | Excel Programming |