TechNet Gallery - resources for IT professionals

Download resources and applications for Windows 7, Windows Server 2008 R2, Windows Server 2008, SharePoint, System Center, Office, and other products. Find resources written in VB Script, PowerShell, SQL, JavaScript, or other script languages. New resources are added frequently so check often and see what's new.

Each contribution is licensed to you under a License Agreement by its owner, not Microsoft. Microsoft does not guarantee the contribution or purport to grant rights to it.
Sort by: rss
87 results in Excel [Clear]
HicanNL
Note: This script is tailored for the project I used it in. It should work out of the box (by only changing the $location variable), but sometimes it doesn't (because of the configuration of Active Directory, missing of the AD Module, etc. etc). Most of the times when it doesn't
(49)
Updated 6/12/2013
Released 4/26/2012
25,378 Downloads
Alessio Giombini
Lync DDC is a simple low-level design calculator for a Lync 2013 Standard or Enterprise deployment. Fill in hostnames, IP and other design elements in the Global Data and Resource Data sheets, and it will calculate DNS records, certificate names, firewall rules and HOSTS entries.
(17)
Updated 12/13/2013
Released 8/28/2013
1,382 Downloads
Peter Kriegel
Export-XLSX
Export PowerShell Objects to Excel .xlsx file without Excel!
These script cmdlet creates a Excel XLSX workbook file and stores the data of the objects that you submit in a worksheet within the workbook.
You can use this script like the Export-CSV cmdlet.
(4)
Updated 11/7/2013
Released 9/7/2013
617 Downloads
Zachary Loeber
Create a full blown Active Directory HTML/PDF/Excel report with powershell which can be produced with any non-privileged domain user account and without any special powershell modules or administrative consoles.
(4)
Updated 11/29/2013
Released 10/18/2013
512 Downloads
Microsoft All-In-One Script Framework - Microsoft
This VBA sample illustrates how to import multiple Access tables to Excel worksheets at once, meanwhile each worksheet‘s name will correspond to each table's name. It can be run on Excel 2003, 2007 and 2010.
(6)
Updated 7/29/2013
Released 8/22/2012
920 Downloads
VBATools
I am pleased to present a new, small application. Addition to Excel, whereby in a simple way you can convert your XLS to CSV, given the different standards of recording it. Export applies to the entire worksheet (the maximum area of ​​use) or for a designated area.
(2)
Updated 12/4/2013
Released 12/24/2011
1,269 Downloads
Valy Greavu, MVP
This article describes the formula syntax and usage of the SUMIFBYCOLOR function in Microsoft Excel.DescriptionYou use the SUMIFBYCOLOR function to sum the values in a range that meet criteria that you specify. For example, suppose that in a column that contains numbers, you want
(2)
Updated 9/21/2012
Released 9/21/2012
955 Downloads
Richard Mueller
A PowerShell V1 script to update users (or any class of AD objects) in bulk from the information in a Microsoft Excel spreadsheet. Only single-valued string attributes are supported.
(16)
Updated 9/17/2011
Released 9/17/2011
3,839 Downloads
Boe Prox
This script allows you to convert one or more CSVs into an Excel file with each CSV being a new worksheet in excel.
(12)
Updated 2/21/2012
Released 9/2/2010
2,900 Downloads
Amol S Patil
This script build to collect Printer details from local, remote or Printer server.Which gives us - Print Server,Printer Name,Port Name,Share Name,Driver Name,Driver Version,Driver,Location,Shared -Details

@===Amol===@
===========================
(2)
Updated 4/17/2013
Released 4/16/2013
496 Downloads
Amol S Patil
This script will help to collect System Information from Local, Remote or Multiple remote computers.
Used Get-WMIObjects to get the required details and will save it in excel. You can change/add the properties as per your requirme
(0)
Updated 3/22/2013
Released 3/22/2013
577 Downloads
Doug Finke
Here is my blog post that explains it in more detail. Plus has some ready to go scripts to try it out.Out-ExcelPivotTable inspects the piped data, sets up the numeric properties as data fields and string properties as row fields.You control what goes in the different pivot fields
(3)
Updated 12/29/2011
Released 12/29/2011
550 Downloads
Deviantz
This script will perform a enumeration of all installed software on a Windows machine using the WMI Class "Product" and will provide you with a dump of all installed apps for review.  The script provides "prompt" boxes for destination host and output locations. It was written by
(4)
Updated 2/2/2012
Released 2/2/2012
1,206 Downloads
Alexandru Dionisie
Create a master page to index all worksheets name and add a hyperlink to them.
(3)
Updated 3/26/2012
Released 2/23/2012
303 Downloads
VBATools
List of uniques is useful in many situations, eg
for the selection of elements in the forms, letters
or designation of the scale validation set.

One of the simplest ways is to create a pivot tabla, which
in its mechanism counts the elements of the counter.
(3)
Updated 10/25/2012
Released 1/8/2012
214 Downloads
1 - 15 of 87 Items