-
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...
-
In today's post, programmer writer Eric Schmidt shows how he took rows in an Excel workbook and generated text files from the data in the rows using Visual Studio 2010, Visual Basic, .NET 4, and Excel 2010. ...( read more ) Read More...
-
In today's blog post, learn how programmer writer, Eric Schmidt, uses Visual Basic code to pull data from text files in a shared folder and then add that data programmatically into an Excel workbook. ...( read more ) Read More...
-
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...
-
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 the SlicerCaches...
-
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 show you how to...
-
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...
-
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.....
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...