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
Normal 0 false false false MicrosoftInternetExplorer4 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...
Nostalgia IS What It Used To Be
Published Thu, Sep 10 2009 9:41 | Bob Phillips
Excel 2007 has had much comment since its introduction, most of which has been centred around the ribbon, is it a piece of inspired insight by MS, or a blunder of enormous proportions? This post will not concern itself over that issue directly, but will...
Ribbons - Gain Without The Pain
Published Wed, Sep 9 2009 10:57 | Bob Phillips
Normal 0 false false false MicrosoftInternetExplorer4 If you are in the habit of building or customising Excel 2007 Ribbons, there is an indispensable new tool that has just hit the market. Andy Pope has released his RibbonX Visual Designer, which can...
Filed under: , , , ,
Conditional Formatting In Excel 2007 - Chav or Mini?
Published Tue, Sep 8 2009 9:06 | Bob Phillips
Yesterday I had an incredibly frustrating time. I was updating my RibbonX Autogen routine to handle more types of controls. This is driven from a worksheet, some columns of which are generated, some of which depend upon user input. So being a helpful...
Filed under: , , ,
Autogen’ed Ribbon Code
Published Mon, Aug 24 2009 13:06 | Bob Phillips
Normal 0 false false false MicrosoftInternetExplorer4 In a previous post, XML Is Such A Pain , I showed the technique that I use to simplify the creation of XML code for custom ribbons. This is a handy technique, as it means that creating the XML is very...
Filed under: , , , , ,
XML Is Such A Pain
Published Tue, Aug 18 2009 12:14 | Bob Phillips
Normal 0 false false false MicrosoftInternetExplorer4 Creating a custom ribbon tab in Excel 2007 is a well known technique by now, and relatively easy to achieve. I will not go into the details here, there are many examples scattered across the web, I...
Filed under: , , , ,
The End Of VBA
Published Fri, Aug 14 2009 8:39 | Bob Phillips
The title was just to get your attention, it really should be entitled something along the lines of “What Made VBA The Success It Is Today?’, as this post is more about what VBA is and isn't, albeit somewhat precipitated by the thought...
Filed under: ,
Keeping It Clear
Published Tue, Aug 11 2009 8:17 | Bob Phillips
It is not my intention for EDDD to be another 'Excel Tips & Tricks' blog, there are plenty of good examples of these already, but I saw someone struggling in a demonstration recently so I am thinking that this technique is not as well know...
Filed under: , ,
More Posts Next page »