Pages

Sunday, 16 May 2010

[Tip] Quick and Dirty Repetitive Command Line Tasks with Excel

At work we had to create folders for all our users. We didn't want to create each folder manually so we went through the following set to accomplish the task (It took about 10 minutes from start to finish):

1. Get a list of users from Active Directory. We have a SQL Server Database with a linked table to Active Directory so we queried that to get a list of usernames.