Welcome to MSDN Blogs Sign in | Join | Help

Microsoft Excel 2010

The official blog of the Microsoft Excel product team

Browse by Tags

All Tags » Programmability   (RSS)
Programmability Improvements in Excel 2010
Thanks to Danny Khen for putting together this post. What’s new? Excel has been a platform for developing business solutions for a long time now. Developers write code to customize and extend Excel in many ways – automating Excel operations, user interface Read More...
Updated Excel Services Web Services API in SharePoint 2010
Thanks to Christian Stich, the founder of Excel Services Consulting, L.L.C. , for putting together this post on the updated Excel Web Services API. The Excel Web Services API that initially shipped with Excel Services 2007 has been updated and expanded Read More...
Introducing the JavaScript Object Model for Excel Services in SharePoint 2010
Thanks to Christian Stich , a consultant working on Excel Services projects, for putting together this series on the Excel Services JavaScript Object Model. Excel Services 2010 has added two entirely new programming APIs: The REST API which I covered Read More...
Excel Services in SharePoint 2010 REST API Examples
Thanks to Christian Stich for putting together this series on the REST API. In this final installment on the REST API, we’ll walk through a couple examples of using the REST API to embed spreadsheet data in new and interesting ways. Embedding a ‘Live’ Read More...
Excel Services in SharePoint 2010 REST API Syntax
Thanks to Christian Stich for putting together this series on the REST API. As we saw in the previous post , using the Excel Services REST API is as simple as specifying a URI (Uniform Resource Identifier) in your web browser. In this post we’ll walk Read More...
Are you an Office Developer? You'll Want to Read This:
Today at the SharePoint conference the Office Developer Marketing Team announced the Office 2010 Application Compatibility Program . Details were posted today at Gray Knowlton's blog . Here's an excerpt from his post: With the great value Office 2010 Read More...
Calculate the ISO Start of Year date
Today’s author is Shane Devenshire, who has been an Excel MVP for many years and who regularly contributes to Excel Newsgroups. He has published over 300 articles in different computer magazines, and co-authored numerous books. Excel might be better today Read More...
Copying Worksheets with a List or Table
Today’s author is Ron de Bruin, an Excel MVP . You can find more useful tips from Ron and links to Excel add-ins at his website: http://www.rondebruin.nl/ Problem : It is not possible to copy more than one sheet to a new workbook or existing workbook Read More...
Creating a Custom Popup Menu
Today’s author is Derek Mang, owner of Systems Solution Developers Inc. You can find more useful tips from Derek on his website: www.officevbasolutions.com . This post shows you how to create a custom popup menu in Excel. Microsoft Excel has lots of popup Read More...
Submit your Power Tips
The Power Tips feature of the Excel Team Blog has started with useful articles from MVPs Ron de Bruin and Jan Karel Pieterse. Thank you both! For everyone else who is interested in contributing to this blog, here’s a quick reminder how the feature works. Read More...
Using parameters with web queries
Today’s author is Jan Karel Pieterse, an Excel MVP. You can find more useful tips from Jan Karel on his website: http://www.jkp-ads.com/ This post shows you how to dynamically work with data from a website in Excel. Introduction Excel provides a very Read More...
Add Buttons to the Quick Access Toolbar and Customize Button Images
Today’s author is Ron de Bruin, an Excel MVP . You can find more useful tips from Ron and links to Excel add-ins at his website: http://www.rondebruin.nl/ This post shows you how to add a button to the Quick Access Toolbar (QAT) for one or all workbooks. Read More...
Use the VBA SaveAs Method in Excel 2007
Today’s author is Ron de Bruin , an Excel MVP. You can find more useful tips and links to Excel add-ins at his website: http://www.rondebruin.nl/ You see a lot of old SaveAs code that does not specify the FileFormat parameter. In Excel versions before Read More...
VBA Coding Contest
I'm passing along some information I think will be interesting to many of the readers of this blog. Test your VBA coding skills and win! MSDN® is sponsoring a coding contest for Office 2007, named OfficePalooza ! This sweepstakes will run two weeks beginning Read More...
Excel VBA Performance Coding Best Practices
Today’s author, Chad Rothschiller, a Program Manager on the Excel team, is back with a follow up from his previous post on VBA and Excel performance . I want to start off this post by thanking everyone who sent in their examples in response to my January Read More...
More Posts Next page »
Page view tracker