Home Library Learn Samples Downloads Support Community Forums
62 out of 145 rated this helpful - Rate this topic

Excel 2013

Office 2013

Published: July 16, 2012

Excel product logo  The following resources will help you quickly get started developing for Excel 2013. You will find in-depth articles, how-to topics, and other resources—from core development concepts to advanced programming techniques―to help you create powerful business and financial solutions.

Learn how to develop VBA for Excel.

Get started

Excel 2013 developer reference
Make a Macro Do Simple Tasks
Using the Vlookup Function in Excel
Editing Data in an Excel 2007 Open XML File with VBA
Working with Lists and Tables in Excel: VBA Samples
Show the Developer Tab
What is a Macro and Why You Should Care
Create or Delete a Macro
Working with Excel 4.0 Macros





Top APIs

Range object
Range members
Workbook object
Workbook members
Application object
Application members
Worksheet object
Worksheet members
Sheets object
Sheets members




Top articles

Using the Solver VBA Functions
Excel 2010 Object Model Changes Since Earlier Versions
New Objects, Collections, and Enumerations
Microsoft Graph Visual Basic Reference Overview
Language-Specific Properties, Methods, and Functions
New Members and Constants
Sending Email to a List of Recipients Using Excel and Outlook
OLE DB for OLAP Properties Used by Excel
Looping Through a Range of Cells
Formatting and VBA Codes for Headers and Footers




Learn how to load, calculate, and display Excel workbooks on SharePoint.

Developer resources

Excel Services Overview
Excel Services Best Practices








Visual How Tos

Retrieving an Entire Workbook or a Snapshot of a Workbook in Excel Services
Developing Custom Applications by Using Excel Web Services in SharePoint Server
Creating Managed-Code UDFs for Excel Services
Adding Excel Web Parts to Pages Programmatically in SharePoint Server
More Excel Visual How Tos





More Excel Services content

An Introduction to Excel Services
Building Custom Solutions
Excel Services Technical Overview
Ten Tips for Using SharePoint Server with Excel Services
Extending the Excel Services Programmability Framework
Overview of Excel Services Architecture
Administer Excel Services in SharePoint Server 2013
Developing BI Applications: What is Business Intelligence?
Interacting with the Excel Web Services API for SharePoint Server
How to: Programmatically Add an Excel Web Access Web Part to a Page

Did you find this helpful?
(1500 characters remaining)
© 2013 Microsoft. All rights reserved.
|
Site Feedback
© 2013 Microsoft. All rights reserved.