All Tags » Excel (RSS)

Browse Blog Posts by Tags

Showing related tags and posts for the Blogs application. See all tags in the site

  • One King Bearing Gifts

    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 utility, which means you have to interrupt your...
    Posted to Excel Do, Dynamic Does by Bob Phillips on Wed, Dec 9 2009
    Filed under: Filed under: , ,

  • You Say CustomUI Editor, I Say TextPad

    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 to validate the XML, but the editing experience is...
    Posted to Excel Do, Dynamic Does by Bob Phillips on Sun, Nov 29 2009
    Filed under: Filed under: , , ,

  • data source reference is not valid - Excel error when adding a pivot table

    I've had this error a few times but never figured out why. With the help of a few posts around the web I finally found out the reason. If you have opened a none excel file like a csv file, then you get this error "Data source reference is not...
    Posted to SimonS Blog on SQL Server Stuff by on Wed, Nov 11 2009
    Filed under: Filed under: ,

  • OpenOffice Is Looking Good

    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, after much trials and tribulations, but I needed to...
    Posted to Excel Do, Dynamic Does by Bob Phillips on Mon, Nov 9 2009
    Filed under: Filed under: , , ,

  • Pride Dispensed, Pride Promised, And Pride To Go

    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 to avoid disappointing the many wait-listed people...
    Posted to Excel Do, Dynamic Does by Bob Phillips on Sat, Oct 10 2009
    Filed under: Filed under: , ,

  • Class Conscious

    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 a series of posts would be useful, so here is the...
    Posted to Excel Do, Dynamic Does by Bob Phillips on Fri, Oct 2 2009
    Filed under: Filed under: , , ,

  • xldynamic Returns

    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 discussion on the web. Around about August 2008...
    Posted to Excel Do, Dynamic Does by Bob Phillips on Mon, Sep 28 2009
    Filed under: Filed under: , , ,

  • Shreds And Patches

    "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 would never forgive me) have been holding Excel...
    Posted to Excel Do, Dynamic Does by Bob Phillips on Sun, Sep 27 2009
    Filed under: Filed under: , , , , ,

  • Ribbons - Gain Without The Pain

    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 be found here . I have blogged previously about how...
    Posted to Excel Do, Dynamic Does by Bob Phillips on Wed, Sep 9 2009
    Filed under: Filed under: , , , ,

  • Conditional Formatting In Excel 2007 - Chav or Mini?

    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 sort of guy, I have decided to shade the input cells...
    Posted to Excel Do, Dynamic Does by Bob Phillips on Tue, Sep 8 2009
    Filed under: Filed under: , , ,

  • Autogen’ed Ribbon Code

    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 simple, it is more or less a cut-and-paste job...
    Posted to Excel Do, Dynamic Does by Bob Phillips on Mon, Aug 24 2009
    Filed under: Filed under: , , , , ,

  • XML Is Such A Pain

    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 would suggest Ron de Bruin’s pages at http...
    Posted to Excel Do, Dynamic Does by Bob Phillips on Tue, Aug 18 2009
    Filed under: Filed under: , , , ,

  • Using Linq with Microsoft Word and Excel

    Some of the collections in the Microsoft Office object models implement IEnumerable. The IEnumerable interface provides the ability to perform a for/each against the collection. With .NET 3.5, a Cast extension method of IEnumerable allows you to work with these collections using Linq. Microsoft Word...
    Posted to Deborah's Developer MindScape by Deborah Kurata on Fri, Aug 14 2009
    Filed under: Filed under: , , , , , , ,

  • The End Of VBA

    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 that VBA must be close to its end game. I recently...
    Posted to Excel Do, Dynamic Does by Bob Phillips on Fri, Aug 14 2009
    Filed under: Filed under: ,

  • Keeping It Clear

    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 as I had presumed, nor as it should be. Therefore...
    Posted to Excel Do, Dynamic Does by Bob Phillips on Tue, Aug 11 2009
    Filed under: Filed under: , ,

  • Custom UDFs

    Normal 0 false false false MicrosoftInternetExplorer4 In Excel 2007, if you start to enter a formula, such as =I, in the formula bar, it immediately provides you with intellisense of all functions starting with I. As with normal intellisense, the more you type, the more precise the list becomes. I am...
    Posted to Excel Do, Dynamic Does by Bob Phillips on Sun, Aug 9 2009
    Filed under: Filed under: , , , ,

  • Too many Modules Spoil the VBA Project?

    So many times you see someone asking about whether they should split their VBA code into many modules, if so, how should they structure it? We probably know that there is a limit to the amount of code that a VBA code module can handle. The code module is essentially an in-file text file (if exported...
    Posted to Excel Do, Dynamic Does by Bob Phillips on Fri, Aug 7 2009
    Filed under: Filed under: , , ,

  • The Glory of Pivots

    Surely we all know how useful Pivot Tables are in Excel by now? They are great for knocking up a filterable, drillable list of the data, but they can be much more. For instance, it is realtively simple to create a Top 10 (or top n) list from your data in a pivot table. To my mind, this sort of table...
    Posted to Excel Do, Dynamic Does by Bob Phillips on Wed, Aug 5 2009
    Filed under: Filed under: , , ,

  • New Server

    Big day today. Just taken delivery of a new server box, dual core with 8Gb and Raid-1. By the cringe, it was a heavy beastie. I will be installing Windows 2008 and SQL Server 2008 on it, as I intend to do some more heavy duty BI (still using Excel to be the presentation layer of course). In due course...
    Posted to Excel Do, Dynamic Does by Bob Phillips on Tue, Aug 4 2009
    Filed under: Filed under: , , ,

  • Why Does Excel Make It So Hard?

    I had a simple requirement recently, I wanted to create a form where it was possible to navigate around using shortcut keys. Easy you would think, just assign accelerator keys to labels and/or commandbuttons ... problem solved. Unfortunately, I also have a number of frames with multiple checkboxes in...
    Posted to Excel Do, Dynamic Does by Bob Phillips on Sun, Aug 2 2009
    Filed under: Filed under: , , , , ,
Page 1 of 2 (35 items) 1 2 Next >