PaulDotCom mailing list archives

Network Admin - User Creation Spreadsheet


From: xgermx at gmail.com (xgermx)
Date: Tue, 1 Sep 2009 12:31:01 -0500

Not to discredit any of your work, but there are already multiple tools to
do this for you. At my company I use a product called AD Bulk Users (
http://www.dovestones.com/products/Active_Directory_User_Import.asp) to add
users/make changes en mass. It does cost $99 but unless you're an extremely
fast coder, it is far cheaper to use this than to code your own (I suppose
it also depends how much you're making hourly).
That being said, you've already done the leg work of coding this, so I'll
definitely be giving it a try.


On Tue, Sep 1, 2009 at 10:49 AM, bytes abit <bytesabit at gmail.com> wrote:

I have created an Excel Spreadsheet that allows one to PASTE a list of
"Last Name, First Name" into the Name column and it auto-generates a batch
file that creates the list of names into Active Directory user accounts.

I have changed some of the random code and aspects to keep my usage hidden,
but have created an example file for the PDC community.


I hope this helps someone out, saves me about 4 hours a month, as we
generate many users.


NOTE:  Some of the options are not available and are simply there for
concept.  Also, this example could be used for any command :)

I also realize this can probably be done in many languages, but I was
teaching Excel at the time and thought it a good example to my class on
embedded formulas :P



The batch file will be created in the same location that the file resides.


++ As per anything, I welcome and suggest you check the code out first to
ensure I have... errrr BOB has not been meddling with the file or trying
something sneaky.





_______________________________________________
Pauldotcom mailing list
Pauldotcom at mail.pauldotcom.com
http://mail.pauldotcom.com/cgi-bin/mailman/listinfo/pauldotcom
Main Web Site: http://pauldotcom.com

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mail.pauldotcom.com/pipermail/pauldotcom/attachments/20090901/c25d4fea/attachment.htm 


Current thread: