Add users to group through excel spreadsheet

[n3tw0rkadm1n1strat0r]

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? I would think this way would be easier because when you have lot of groups, it would be easier to find and add that member. If anyone knows how to do this let me know. Thanks.

 

[SkipVought]

Hi,

What's the table structure?

Have your looked at Data/Form?

Have you tried Data/AutoFilter?

Skip,
[sub]
[red][/red]
[/sub]

 

[n3tw0rkadm1n1strat0r]

Hey thanks for replying, I have not looked at this, I really don't know where to start and how to do this, can you help me out?

 

[SkipVought]

This is a forum for professionals, not people who "have not looked into" anything. We can provide TIPS to help. This is not a HELP DESK.

You need to describe your situation in professional terms in order to get a professional answer.

Skip,
[sub]
[red][/red]
[/sub]

 

[xlbo]

Are you asking about Active Directory groups???

seems so but you need to state your requirements, applications & processes in more detail

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[n3tw0rkadm1n1strat0r]

Yes I am talking about active directory groups, and I looked over the Data/Autofilter, this is not the feature that I am looking for. I need to somehow integrate a vbs script into the excel spreadsheet...and believe me I have researched on this, and I have found nothing which is why I am posting on a forum, for help. The only information I have found is using a vbs script that reads users from and excel spreadsheet and puts them in the specified group...but I want to do the opposite. Click a cell in a spreadsheet, which will be a certain group, and type in the user\users to add (with an input box, or however it can be done). That is what I am trying to accomplish.

 

[KenPuls]

Hi there,

I'm not sure I quite followed that last bit. You have a VBS script to take a bunch of users listed in an Excel sheet and put them in a group. What you want to do is place a single user in a group. Is that correct?

If that's the case, please post the VBS script, and I'm sure that we can modify it. VBS and VBA (used in Office) are very similar, so it shouldn't be too hard if I was right on both points above.

Ken Puls, CMA

http://www.excelguru.ca

 

[n3tw0rkadm1n1strat0r]

I have the script to add a user to a group, thats not hard, its being able to integrate it with the excel spreadsheet...I'm try to explain it the best I can. The only way I can say it is that for each cell that a group name is in, a script will go along with it, so when you click/select the cell an on click event will activate the script that goes along with that cell. That is the only way I can think of doing this.

 

[firefytr]

Post all of your code please.

Regards,
Zack Barresse

Simplicity is the ultimate sophistication. What is a MS MVP? PODA
- Leonardo da Vinci

 

[KenPuls]

We can use a Worksheet_BeforeDoubleClick event, check the value of the target, and probably even feed it into a single modfiied version of your script.

As Zack reiterated, though, we need to code to help you convert it.

Ken Puls, CMA

http://www.excelguru.ca