Solved

Create user accounts from an excel spreadsheet

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

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Question has a verified solution.

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

Deploying a Microsoft Access application in a Citrix environment is not difficult but takes a few steps. However, Citrix system people are often of little help, as they typically know next to nothing about Access. The script provided here will take …
While rebooting windows server 2003 server , it's showing "active directory rebuilding indices please wait" at startup. It took a little while for this process to complete and once we logged on not all the services were started so another reboot is …
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 to another domain controller. Log onto the new domain controller with a user account t…
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 …

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