SharePoint 2007 - Extract SharePoint Users informations to an Excel file format

Monday, 12 October 2009 09:57 by myro

SharePoint 2007 is missing a feature that lets you export all Users that belong to a particular group into a Excel compatibile file format. What happens if someone asks you: "May I have a list of all users that belongs to a particular group?". Would be nice to have a simple Form Application that saves the list provinding for each user informations like the domain name, the full name and the email?

With just few lines of code you can accomplish that or if you prefer, you can download my little project: SharePoint Group Users Info which does exactly this job:

Once you have insered your SharePoint's site url, click the Get Groups button. Select the group you wish to export and press Get Users Info. A Save File Dialog will pop up, asking you where would you save your CVS file. Open it with Excel and you are done!

Download Visual Studio 2008 Project: SharePointGroupUsersInfo.rar (70.63 kb)

Be the first to rate this post

  • Currently 0/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5
Tags:  
Categories:   SharePoint 2007
Actions:   Bookmark and Share | Permalink | Comments (0) | Comment RSSRSS comment feed
If you consider this post usefull for your purposes, please consider visiting my sponsors to help me out with the myrocode.com maintenance. Thank you.