Question Locked

Can you use Excel to manage Active Directory?

0 helpful
8 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Can i use Excel as a list of users and then import the users to Active Directory?
A example of how Excel might look like:
http://i.imgur.com/Jzx8f.png

And also if anyone is hardcore to Excel, how do i make a random password generator?

Martin Hansen

8 replies

by dr_shivan

Paste the below into a cell and span across as many as you like.
=CHAR(RANDBETWEEN(33,126))
This will randomly generate a character from the alphanumeric+special key.
string the result and you get your random password.

by martinohansen

I wont it to give me a 8 characters long password with lower case and upper case letters + numbers
I cant get =CHAR(RANDBETWEEN(33,126)) to that

by markp24

Hi,

not sure if this fits what your looking for, but i have our sales system export new client account to a XLS file, then user VBscript to import and populate the system we use for our clients with the information, as well as setup a home folder, prepopulate it with required files (its a TS /Citrix type envirnment. if you want to see that let me know.

by martinohansen

Im working on my exam at the moment so i would be really happy to see it!

This discussion is closed to new replies.