Announcement

Collapse
No announcement yet.

add users to group through excel spreadsheet

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • add users to group through excel spreadsheet

    So lets say you have the group name in one cell, and you click on it, it would then prompt you for the users name. Once you put that in you hit ok and it would add that user to the group. Can this be done?

  • #2
    Re: add users to group through excel spreadsheet

    This is really an Excel / VBA / Scripting issue rather than an Active Directory one.

    It is easy enough to do provided you understand Excel.

    Search for Add User To Group Using VBScript for the AD bit....

    It seems a bit odd, though, why not have a list of users and groups in Excel, then process them in a batch?
    Tom Jones
    MCT, MCSE (2000:Security & 2003), MCSA:Security & Messaging, MCDBA, MCDST, MCITP(EA, EMA, SA, EDA, ES, CS), MCTS, MCP, Sec+
    PhD, MSc, FIAP, MIITT
    IT Trainer / Consultant
    Ossian Ltd
    Scotland

    ** Remember to give credit where credit is due and leave reputation points where appropriate **

    Comment


    • #3
      Re: add users to group through excel spreadsheet

      Well the reason I want to do it this way is because I always don't have a lot of users to add to a 1 group, but different users in a lot of different groups. So I thought it would just be easier to have a speadsheet of all the groups, be able to click that cell with the group and put the users name it. It just seems like an easier layout to me.

      Comment

      Working...
      X