Browse by Tags
All Tags »
Programmability (RSS)
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
