Excel User Group
Microsoft Excel blogs, forums, files. Read, ask questions, provide answers.
The Excel Team Blog » All Tags » Programmability (RSS)

Browse by Tags

  • Vote for the prototype you like for the Open XML SDK

    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 Read More...

  • Creating a TOC with Hyperlinks Programmatically

    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().Count property, introduced in Excel 2007, to calculate the number of pages on each sheet. In addition, the entries in the TOC link to their respective sheets to improve on-screen workbook navigation...

  • Creating Address Labels from a Spreadsheet Programmatically

    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". The addresses on the Addresses sheet must be arranged as one address per row, with the Name in Column A, Address Line 1 in Column B, Address Line 2 in Column C, and the City...

  • Add a Table of Contents to your Workbook Programmatically

    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 the corresponding printed page numbers, is listed in the table of contents. To retrieve the page numbers the example opens the Print Preview dialog box. You must close the dialog box...

  • Hover Charts

    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 - especially for filtering. Of course, we've made it a little less necessary in the 2007 and 2010 releases, since table headers (2007) and now table filters (2010) automatically camp...

  • Migrating Excel 4 Macros to VBA

    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 macro language prior to the introduction of VBA in Excel 5.0. Most people have long since migrated their Excel 4 macros to VBA; however, some Excel 4 macro capabilities were missing from VBA, which...

  • 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 customizations, data entry forms and extending Excel formulas with user defined functions, to name some key ones. Many developers create very complex applications, which have demanding requirements and push Excel to its limits, so developers are...

  • 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 for Excel Services in SharePoint 2010. I will address the additions and changes for the Excel Web Services API for SharePoint 2010 in this post. Additional information about the Web Services API covering the 2007 implementation can be found in the...

  • 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 in an earlier series of posts and the JavaScript Object Model (JSOM) which I will discuss in this post. The JavaScript Object Model (JSOM) enables a whole new set of solutions using Excel Services. With the JSOM it is possible to detect and react to...

  • 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’ Chart on a SharePoint Wiki Page. For this example we are embedding an Excel scatter chart on a SharePoint wiki page. The scatter chart works like an analog clock, so that you can see that the data returned via REST is dynamic, and the workbook containing...

  • Excel Services in SharePoint 2010 REST API Syntax

    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 with a simple Excel workbook stored on a SharePoint 2010 server at the following URL: http://contoso/Finance/Shared%20Documents/Tax.xlsx This example workbook contains two named ranges, a chart, a table and a PivotTable. In order to create a URI that can be used to access the...

  • 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 brings for end users, IT Professionals and Developers, we are also investing heavily in making deployment of the new version of Office easier. As part of our focus on deployment, we have renewed priority on helping ensure applications and Add...

  • 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 because of the many bugs he posted when he was a Beta tester! This post shows you how to use a formula or custom VBA function to calculate the ISO Start of Year date. Here is a formula for calculating the ISO Start of Year date for any legal Excel...

  • 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 if there is a List (Excel 2003) or a Table (Excel 2007) in one of the worksheets. How to reproduce: In a new workbook with two or more sheets, add a table or a list in one of the worksheets. Select more than one sheet with the CTRL key held down. (Be...

  • 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 menus that are made available to the user with a right-click depending on what your doing - hence the term context menu. Right-click on a cell and you get the Excel "cell" popup menu and its available choices. This menu is subject to customization...
1 2 3 Next >
Copyright Excel User Group and the relevant contributors, 2010. All Trade Marks acknowledged. This site is a peer-to-peer site and NOT affiliated in any way to Microsoft Corp. All rights reserved.