Results for:
programmability

• IF and only IF (video)

  29 Mar 2011

  This post is all about IF--not the poem by Rudyard Kipling, or the 1971 hit song by Bread, but the function . The IF function is used in many Office programs, but most of us know it from Microsoft Excel: IF(logical_test, [value_if_true], [value_if_false]) IF is one of the most searched-for words on Office...
• Working backward: rows to text files

  24 Feb 2011

  You may remember this graphic from my previous post : It was totally staged. A fabrication. Well, the PowerPoint templates are the original files - so it wasn't completely faked. But I added all of the text files back into the folder in order to create the image. As I worked on the previous post, I realized...
• Manually paste text into a workbook? No way!

  17 Feb 2011

  Recently, I had a bunch of cool PowerPoint 2010 templates that I wanted to publish. A colleague was going to take each template and a short paragraph describing the template and create the downloadable files. So I saved the PowerPoint templates (.potx) to a network file share and then created a matching...
• Control slicers by using VBA

  27 Jan 2011

  Today’s author is Jan Karel Pieterse, an Excel MVP, who explains how to work with the SlicerCache object, and how customize buttons or change slicer properties by using VBA. For more information about slicers, read PivotTable Slicers on Jan Karel’s website: http://www.jkp-ads.com/ . Juggling...
• Add a table of contents to your workbook – it’s easy, I promise!

  13 Jan 2011

  Sometimes workbooks can be very large and hard to navigate. Only so many tabs fit across the bottom of the screen, and it’s hard to know how long each worksheet is. Excel doesn’t have a built-in way to add a table of contents to a workbook; however, there is a way! In this post, I’ll...
• Pulling RSS data into Excel (or: Using Excel to Search Craigslist) - Part 1

  12 Oct 2010

  This blog post is brought to you by Dan Battagin a Lead Program Manager on the Excel team. OK, so I'm going to talk a bit about a relatively unknown feature in Excel: XML data import. It was introduced in Excel 2003, but we've done a pretty good job hiding it since Excel 2007 by putting it on the Developer...
• Vote for the prototype you like for the Open XML SDK

  14 Jul 2010

  The developer documentation team is asking for your feedback on a couple prototypes for the Open XML SDK Documentation. Visit their blog to download the prototypes and vote: http://blogs.msdn.com/b/officedevdocs/archive/2010/07/13/vote-for-the-prototype-you-like-for-the-open-xml-sdk.aspx
• Creating a TOC with Hyperlinks Programmatically

  30 Apr 2010

  Today's author is Dennis Wallentin, XL-Dennis, of http://xldennis.wordpress.com/ A few weeks ago we posted a code example for creating a table of contents for your workbook. Dennis offers another approach with this code sample for creating a TOC with hyperlinks. Dennis’ code uses the PageSetup.Pages...
• Creating Address Labels from a Spreadsheet Programmatically

  14 Apr 2010

  Today's author is MVP Bill Jelen of MrExcel.com . The following code example takes a list of addresses arranged as one address per row, and copies them onto another sheet, arranging them to fit on printable address labels. The workbook must contain two sheets, one named "Addresses" and one named "Labels...
• Add a Table of Contents to your Workbook Programmatically

  7 Apr 2010

  Today's author is MVP Bill Jelen of MrExcel.com . The following code example verifies that a sheet named "TOC" already exists. If it exists, the example updates the table of contents. Otherwise, the example creates a new TOC sheet at the beginning of the workbook. The name of each worksheet, along with...
• Hover Charts

  11 Mar 2010

  Thanks to Dan Battagin for writing this blog post. OK, so I'm sure everyone knows about the Freeze Panes feature in Excel - it's been around forever, and it's pretty useful in certain circumstances where you want to keep a row (or more) of data at the top of the sheet, or column on the side of the sheet...
• Migrating Excel 4 Macros to VBA

  16 Feb 2010

  Thanks to Eric Patterson for writing this blog post. As promised in our Programmability Improvements in Excel 2010 , here are more details about the Excel 2010 improvements to aid in migrating Excel 4 Macros to VBA. Excel has a macro facility, known as Excel 4 macros (XLM for short) that was the primary...
• Programmability Improvements in Excel 2010

  27 Jan 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 customizations, data entry forms and extending...
• Updated Excel Services Web Services API in SharePoint 2010

  6 Jan 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 for Excel Services in SharePoint 2010. I will address...
• Introducing the JavaScript Object Model for Excel Services in SharePoint 2010

  30 Nov 2009

  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 in an earlier series of posts and the JavaScript Object...
• Excel Services in SharePoint 2010 REST API Examples

  9 Nov 2009

  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’ Chart on a SharePoint Wiki Page. For this example...
• Excel Services in SharePoint 2010 REST API Syntax

  5 Nov 2009

  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 through the details of the URI syntax. We start out...
• Are you an Office Developer? You'll Want to Read This:

  22 Oct 2009

  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 brings for end users, IT Professionals and Developers...
• Calculate the ISO Start of Year date

  17 Sep 2009

  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 because of the many bugs he posted when he was...
• Copying Worksheets with a List or Table

  31 Aug 2009

  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 if there is a List (Excel 2003) or a Table (Excel...