[2 days left] What’s wrong with your cloud strategy? Learn why multicloud solutions matter with Nimble Storage.Register Now

x
?
Solved

Create user accounts from an excel spreadsheet

Posted on 2011-03-15
4
Medium Priority
?
1,021 Views
Last Modified: 2012-05-11
Need a script to create multple user accounts from a spreadsheet.
0
Comment
Question by:ntr2def
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

Problems using Powershell and Active Directory?

Managing Active Directory does not always have to be complicated.  If you are spending more time trying instead of doing, then it's time to look at something else. For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why

Question has a verified solution.

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

Active Directory can easily get cluttered with unused service, user and computer accounts. In this article, I will show you the way I like to implement ADCleanup..
It’s time for spooky stories and consuming way too much sugar, including the many treats we’ve whipped for you in the world of tech. Check it out!
This video shows how to use Hyena, from SystemTools Software, to bulk import 100 user accounts from an external text file. View in 1080p for best video quality.
There are cases when e.g. an IT administrator wants to have full access and view into selected mailboxes on Exchange server, directly from his own email account in Outlook or Outlook Web Access. This proves useful when for example administrator want…
Suggested Courses

649 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