Solved

Create user accounts from an excel spreadsheet

Posted on 2011-03-15
4
1,011 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 500 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

Maximize Your Threat Intelligence Reporting

Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

Join & Write a Comment

Mapping Drives using Group policy preferences Are you still using old scripts to map your network drives if so this article will show you how to get away for old scripts and move toward Group Policy Preference for mapping them. First things f…
Restoring deleted objects in Active Directory has been a standard feature in Active Directory for many years, yet some admins may not know what is available.
This tutorial will walk an individual through the steps necessary to join and promote the first Windows Server 2012 domain controller into an Active Directory environment running on Windows Server 2008. Determine the location of the FSMO roles by lo…
This tutorial will walk an individual through the process of transferring the five major, necessary Active Directory Roles, commonly referred to as the FSMO roles from a Windows Server 2008 domain controller to a Windows Server 2012 domain controlle…

758 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

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now