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
7 results in Excel 2010 [Clear]
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
(12)
Updated 6/4/2011
Released 6/4/2011
12,124 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,268 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
(2)
Updated 6/4/2011
Released 6/4/2011
3,631 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
The WorksheetFunction object in VBA gives your code the ability to use the worksheet functions that are part of Microsoft Excel 2010. The VBA example in this download accompanies the technical article "Using Worksheet Functions from VBA Code in Excel 2010."

System Requirement
(3)
Updated 6/4/2011
Released 6/4/2011
4,189 Downloads
SS. Kanagal Jr
Auto Update/populate values. Here, I show how to populate different values in a excel cell depending upon the selection made in dropdown list in another cell. Download the example for a quick logic/try out.
(1)
Updated 1/24/2012
Released 1/24/2012
103 Downloads
Joao Livio
Sometimes it is necessary use Excel automation in order to grab some information from a specific data source and put it in Excel directly. The objective is to get more control about what you need to do to pull and create automatic processes to the end-user.This project is a Docum
(1)
Updated 5/11/2012
Released 5/11/2012
82 Downloads
SS. Kanagal Jr
Execute excel macro from Access database. I present an example of how to call and execute a code in a excel macro module to return the results.
(1)
Updated 1/24/2012
Released 1/24/2012
19 Downloads