Excel Programming
An Excel Programmability blog by Gabhan Berry
Custom Task Panes
A Custom Task Pane (CTP) is a user interface component in Office which is used to provide a...
Date: 08/13/2008
How to code a .NET RefEdit Control
One of the controls frequently used by Excel is the reference edit box. This control is used to...
Date: 06/11/2008
Busy Times ... and a Note about my TechEd Sessions
Busy times at Microsoft has meant that I've been slower than usual in posting recently. My current...
Date: 04/25/2008
Writing Custom Excel Worksheet Functions in C#
Writing our own, custom worksheet functions is a great way to extend Excel. Before Excel 2002 we...
Date: 04/07/2008
Using Statistics in Business Intelligence
One other area I work in is Business Intelligence. These days BI is an important technology to an...
Date: 04/04/2008
OOXML wins ISO Vote
Office Open XML (OOXML), the XML file formats used by Office 2007, today won the ISO vote which...
Date: 04/01/2008
Open XML SDK Roadmap Announced
The new XML file formats in Office 2007 open the door to lots of exciting programmability solutions....
Date: 03/20/2008
Analysing Column Data using C# (... with a little Custom Drawing thrown in for fun)
When presented with a table of data in Excel, sometimes it is useful to be able to learn some quick...
Date: 03/10/2008
Using Custom Functions in Dynamic Ranges
Named ranges are great. They enable us to assign a name to a collection of cells and use that name...
Date: 02/19/2008
Ribbon Customisation Links
I thought it would be useful to provide a list of some good articles on customising the Office...
Date: 02/14/2008
Excel Event Handling in C#
After I posted about getting up-and-running with managed code and Excel, I realised that I was...
Date: 02/12/2008
The Woes of Excel's Optional Parameters and C# ... a (potential) Workaround
When coding in C# with Excel, it doesn't take long before you encounter the dreaded 'optional...
Date: 02/06/2008
Creating Custom Calculated Members and Sets in OLAP PivotTables
If you are using PivotTables against an OLAP data source you may find it useful to be able to create...
Date: 02/06/2008
MSDN Code Gallery
We have recently launched a code sharing community web site called MSDN Code Gallery. MSDN Code...
Date: 02/05/2008
Using Cell Text to Filter PivotTables
Sometimes it would be useful to be able to use cells to select items in a PivotTable. For example,...
Date: 01/31/2008
Excel and Managed Code ... How does that work?
As well as C/C++ and VBA, I'll be blogging a lot about managed code. So I figured it would be useful...
Date: 01/30/2008
Well ... let's get started
<Fanfare>Hello. My name is Gabhan and this is my new blog dedicated to Excel...
Date: 01/29/2008