Cycling Through The Fog
Published Thu, Jan 7 2010 13:19 | Bob Phillips
Dynamic Analysis Excel 2007 provides the capability to have a pivot table connected to an OLAP cube. Furthermore, detailed analysis can be built by using various CUBE functions. One of the great things about Excel 2007 pivots and CUBE functions is that...
Filed under: , , , , ,
Early Enough For You?
Published Tue, Dec 15 2009 15:24 | Bob Phillips
Interesting post from Jeff Attwood . He makes good points about not pushing your code the extra mile to get it absolutely perfect before shipping, although the Rumsfeld quote is always unfortunate IMO, and there is a lot of truth in it. However, it is...
Filed under: ,
Conditionally Yours
Published Mon, Dec 14 2009 14:23 | Bob Phillips
VBA is a very simple language and programming environment, very easy to get something up and running very quickly, but it is showing its age these days, and with Microsoft making no improvements to the language it will not get better. Which all means...
Filed under: , , ,
One King Bearing Gifts
Published Wed, Dec 9 2009 11:28 | Bob Phillips
I got a new laptop on Friday (my old one gave up the ghost as explained here ). One of the major pains of a new laptop is re-installing all of those applications. It takes so long, and inevitably you will be working and you realise that you need another...
Filed under: , ,
You Say CustomUI Editor, I Say TextPad
Published Mon, Nov 30 2009 0:11 | Bob Phillips
I have written before about hand-crafting XML so as to customise an Office 2007 ribbon at XML Is Such A Pain and Autogen’ed Ribbon Code As I have mentioned before, the CustomUI editor is far from perfect. It does allow adding of image files and...
Filed under: , , ,
Styles AIn't What They Used To Be
Published Fri, Nov 27 2009 10:58 | Bob Phillips
Everybody knows that if you are going to create a meaningful document in Word, you use Styles. Excel has styles as well, but how many of us use these built-in styles, or add to them with our own custom styles? I have been building a styles utility recently...
Filed under: ,
Keep It Simple
Published Tue, Nov 24 2009 22:11 | Bob Phillips
We all know that coding is great fun, even code design is fun, but testing and debugging are most certainly not fun. As such, we have to do what we can to lighten that burden. One of my underlying principles in coding is in keeping the code well structured...
Regression Can Be Sweet
Published Tue, Nov 17 2009 0:07 | Bob Phillips
My laptop blew this last weekend. Unfortunately, my backups were yet to be done, so I have lost a fair amount of work. That is incredibly frustrating, but this post is on another topic. I was an Excel 2000 user for many years. I did dabble with 2002/XP...
OpenOffice Is Looking Good
Published Mon, Nov 9 2009 12:45 | Bob Phillips
Normal 0 false false false MicrosoftInternetExplorer4 I have blogged previously about what a rubbish job MS have done with Conditional Formatting in Excel 2007, but it seems it is worse than I feared. In this same file I now had CF setup as I wanted,...
Filed under: , , ,
Coding Hurts, But the Ribbon Breaks Your Heart
Published Thu, Oct 15 2009 13:27 | Bob Phillips
Normal 0 false false false false EN-US X-NONE X-NONE MicrosoftInternetExplorer4 I was building a ribbon this week (yes, I can’t get enough of them), when I cam across what is a really stupid problem. My application is building a cascading dynamic...
Pride Dispensed, Pride Promised, And Pride To Go
Published Sat, Oct 10 2009 17:17 | Bob Phillips
Normal 0 false false false MicrosoftInternetExplorer4 Just got back from London yesterday after the UK Excel Conference . A successful couple of days I think, we had a large audience, few no-shows, and a general good time. As this was organised mainly...
Filed under: , ,
Class Conscious
Published Fri, Oct 2 2009 16:23 | Bob Phillips
Normal 0 false false false MicrosoftInternetExplorer4 This is going to be the first in a series of items about Code Generation , automatically generating your code. I have posted a couple of times previously on this topic, here and here , but I thought...
Filed under: , , ,
xldynamic Returns
Published Mon, Sep 28 2009 12:02 | Bob Phillips
Normal 0 false false false MicrosoftInternetExplorer4 I have a website http://www.xldynamic.com/ which tries to provide some useful Excel information, different to the many other Exel websites. This site includes what is probably the most useful SUMPRODUCT...
Filed under: , , ,
Shreds And Patches
Published Sun, Sep 27 2009 11:24 | Bob Phillips
"Man is physically as well as metaphysically a thing of shreds and patches, borrowed unequally from good and bad ancestors, and a misfit from the start" (Ralph Waldo Emerson) A number of us British Excel’ers (I nearly said English, Roger...
Filed under: , , , , ,
Hand-holding for Dummies
Published Fri, Sep 25 2009 11:56 | Bob Phillips
Normal 0 false false false MicrosoftInternetExplorer4 I am an inveterate builder of addins for Excel. They are so flexible, so easy to build, but they have a potential deployment issue. Yes I know that for most of you installing an addin is trivial, but...
Time has come today
Published Thu, Sep 24 2009 16:37 | Bob Phillips
Normal 0 false false false MicrosoftInternetExplorer4 I saw a question in the newsgroups today where a guy was asking how he could get more than 10,000 hours in a cell, adding a hour number larger that 10,000 to another time number the formula did not...
Names Should Be Seen
Published Wed, Sep 23 2009 16:41 | Bob Phillips
Normal 0 false false false MicrosoftInternetExplorer4 Doing some work on an Excel spreadsheet this morning reminded me that there are some great products that have been developed that enormously enhance the ease of use, flexibility, and general usefulness...
As Constant As The Wind
Published Mon, Sep 14 2009 14:50 | Bob Phillips
I had an odd problem with VBA today. I used a table driven menu builder (don't we all), and I define the column numbers of that table in an enumerated list. This is that list Private Enum CB_COLUMNS CB_LEVEL_COL = 1 CB_CAPTION_COL = 2 CB_POS_MACRO_COL...
Clear As Mud
Published Mon, Sep 14 2009 9:49 | Bob Phillips
Normal 0 false false false MicrosoftInternetExplorer4 A question on one of the forums recently asked about hiding sheets in a workbook to be posted as an example, but where that workbook contained sensitive information. As I replied, hiding the sheets...
What's My Type?
Published Sat, Sep 12 2009 23:12 | Bob Phillips
I am a big advocate of using the Enum construct in VBA, I feel that it is a simple way of adding a set of values, and provides a grouping, abstracting advantage that is not given by simple variables. Plus they can add to intellisense. As such, I should...
More Posts Next page »