Please Read: Significant Update Planned, Migrating Forum Software This Month

See more
See less

add users to group through excel spreadsheet

  • 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+
    IT Trainer / Consultant
    Ossian Ltd

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


    • #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.