Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Getting Workgroup ID??
Our company has various offices, and i am trying to define which server
the user is on. eg at login thecompany.Edinburgh.tree thecompany.Glasgow.tree I have no idea of how to find the server via excel however. Rightclicking on "my computer" and going to the "computer name" tab, allows me to see the Full computer name and the workgroup. (The workgroup being "EDINBURGH") I came across this macro in my searching and it has the UserDomain which is the same as the "computer name" Sub env() Dim EnvString As String Indx = 1 Do EnvString = Environ(Indx) Cells(Indx, 1) = EnvString Indx = Indx + 1 Loop Until EnvString = "" End Sub So i was wondering if there was any way to get the workgroup. I also tried getting the server via the groupwise library, but failed miserably. I thought if i could get the current users DistinguishedName (NDS) or Groupwise email address as opposed to the normal email address, i could parse out the extra data. If anyone can advise on how this might be achieved i shall be extremely grateful. regards George |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
workgroup | Excel Worksheet Functions | |||
Delete Workgroup | Excel Discussion (Misc queries) | |||
workgroup | Excel Programming |