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
607 Office results [Clear]
OneScript Team - Microsoft
This VBA sample illustrates how to save attachments from multiple selected items in Outlook.
(41)
Updated 7/29/2013
Released 8/22/2012
26,830 Downloads
David J Parker MVP
Microsoft Visio 2007 Professional and 2010 Professional and Premium includes the
Network / Rack Diagram template, which opens the Rack-mounted equipment stencil. This stencil includes the
Patch Panel master which can be stretched from 2U to 25U high.
However, I have often req
(14)
Updated 2/21/2013
Released 9/11/2012
22,011 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.
(14)
Updated 2/21/2012
Released 9/2/2010
5,322 Downloads
Andreas Molin
Both Dropbox and Google Drive have become more popular to share files with others and to keep an extra copy of documents, pictures and so on. This Powershell script will add your Dropbox and Google drive folders as save locations in Microsoft Office 2013.
(13)
Updated 2/10/2014
Released 2/9/2014
4,408 Downloads
Andreas Molin
Add Dropbox and Google Drive as save locations in Office 2013.
(17)
Updated 2/9/2014
Released 1/8/2013
7,208 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.
(16)
Updated 5/13/2014
Released 9/7/2013
3,766 Downloads
Microsoft Office Developer Documentation Team

Microsoft Office Developer Documentation Team MSFT

Microsoft Office Developer Documentation Team samples are developed and tested by the Office Developer Documentation Team to ensure that you have a great experience.

View samples
- Microsoft
You can use VBA code to create PivotTable reports and charts repeatedly and efficiently. The VBA example in this download accompanies the technical article "Creating PivotTable Reports and Charts with VBA in Excel 2010."

System Requirements:
This download works with the f
(14)
Updated 6/4/2011
Released 6/4/2011
18,090 Downloads
Somkiat Foongkiat - Bangkok, Thailand
FIFO calculation with Excel Data Table(Inventory ID is selectable in this sample) Table C6:E15 keeps inventory inward data for all inventory id ordered by its occurrance.Cell H2 is total unit sold of inventory id that selected in cell H3.Table F6:F15 calculates number of unit sol
(5)
Updated 9/15/2012
Released 9/15/2012
6,158 Downloads
mickestyer
Conversion of Outlook PST files in multiple file formats such as PDF, EML, MSG and contacts to individual VCF (vCard) formats to make emails more capable. Outlook PST converter smoothly perform conversion as user need and also allow to extract PST file even Outlook not installed.
(6)
Updated 2/9/2013
Released 1/30/2013
3,832 Downloads
OneScript Team - Microsoft
This script sample shows how to convert Word document to PDF file.
(2)
Updated 7/29/2013
Released 6/28/2013
3,119 Downloads
Steve Halligan
This script can take an ImmutableID found in the DirSync Metaverse (called the SourceAnchor there) or via get-msoluser and output the GUID of the corresponding object from the SOURCE AD. It can also take the Source AD GUID and tell you what the ImmutableID should be.  Useful in t
(2)
Updated 11/13/2012
Released 11/13/2012
2,233 Downloads
Microsoft Office Developer Documentation Team

Microsoft Office Developer Documentation Team MSFT

Microsoft Office Developer Documentation Team samples are developed and tested by the Office Developer Documentation Team to ensure that you have a great experience.

View samples
- Microsoft
You can create VBA code that runs when something happens in a workbook, such as opening the workbook, making or changing the selection on a worksheet, right-clicking, or switching worksheets. The VBA example in this download accompanies the technical article "Running VBA Code Whe
(3)
Updated 6/4/2011
Released 6/4/2011
5,496 Downloads
Adam Conkle - MSFT - Microsoft
Office 365 customers can set the thumbnailPhoto attribute in on-premise Active Directory to have user photos synchronized to Office 365 via Directory Synchronization (DirSync). Exchange Online limits photo size to 10KB. The script sample obtains photo size from Active Directory.
(2)
Updated 7/20/2012
Released 7/20/2012
1,863 Downloads
Microsoft Support for Office Deployment
ROIScan is a VBScript to inventory all Microsoft Office installations on the computer to aid in troubleshooting patch and product installation issues.

Ver 1.7.2
(12)
Updated 3/5/2014
Released 5/18/2011
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
(4)
Updated 9/21/2012
Released 9/21/2012
2,447 Downloads
1 - 15 of 607 Items