[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Create user accounts from an excel spreadsheet

Posted on 2011-03-15
4
Medium Priority
?
1,025 Views
Last Modified: 2012-05-11
Need a script to create multple user accounts from a spreadsheet.
0
Comment
Question by:ntr2def
  • 2
4 Comments
 
LVL 11

Expert Comment

by:RickSheikh
ID: 35141055
0
 
LVL 1

Author Comment

by:ntr2def
ID: 35141173
Nope need a Vb script. I can do it in powershell
0
 
LVL 11

Expert Comment

by:RickSheikh
ID: 35141267
0
 
LVL 65

Accepted Solution

by:
RobSampson earned 2000 total points
ID: 35143579
There's an example of creating user from Excel here:
http://www.experts-exchange.com/Programming/Languages/Visual_Basic/VB_Script/Q_26460342.html

This is the structure of the Excel spreadsheet:
      strGivenName = Trim(objExcel.ActiveSheet.Cells(intRow, "A").Value)
      strSurname = Trim(objExcel.ActiveSheet.Cells(intRow, "B").Value)
      strUserName = Trim(objExcel.ActiveSheet.Cells(intRow, "C").Value)
      strDescription = Trim(objExcel.ActiveSheet.Cells(intRow, "D").Value)
      strDisplayName = Trim(objExcel.ActiveSheet.Cells(intRow, "E").Value)
      strOffice = Trim(objExcel.ActiveSheet.Cells(intRow, "F").Value)
      strPhone = Trim(objExcel.ActiveSheet.Cells(intRow, "G").Value)


Regards,

Rob.
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Uncontrolled local administrators groups within any organization pose a huge security risk. Because these groups are locally managed it becomes difficult to audit and maintain them.
Group policies can be applied selectively to specific devices with the help of groups. Utilising this, it is possible to phase-in group policies, over a period of time, by randomly adding non-members user or computers at a set interval, to a group f…
This tutorial will walk an individual through the process of configuring their Windows Server 2012 domain controller to synchronize its time with a trusted, external resource. Use Google, Bing, or other preferred search engine to locate trusted NTP …
Attackers love to prey on accounts that have privileges. Reducing privileged accounts and protecting privileged accounts therefore is paramount. Users, groups, and service accounts need to be protected to help protect the entire Active Directory …
Suggested Courses

831 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question