It works a treat. I get the users and all their shares too. All I need is the user names so I'll customise it as needed. Thanks a stack for the help.
I'm putting together a Flexi time schedule for each user at our company and I want the user to just click a button and his username and machine name (I have code for that) as well as the date & time will be entered into a worksheet. But if the user is away from their machine and/or in the field (we are an engineering firm) the user must be able to select their own username and add that value to the flexi time sheet.