All Tags » excel (RSS)

Browse Blog Posts by Tags

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

  • 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: , , , , ,

  • Writing Data from a DataTable to Excel

    As with most things in Visual Studio, there are many ways to export data from your .NET application to an Excel spreadsheet. This post covers one straightforward technique. First, set a reference to the desired version of the Microsoft Excel Object Library from the COM tab of the Add Reference dialog...
    Posted to Deborah's Developer MindScape by Deborah Kurata on Thu, Jul 23 2009
    Filed under: Filed under: , , , , ,

  • Excel dates counted differently and a reliable way of working out the day of the week

    Following my recent post about 40,000 days , I got a couple of emails telling me that Excel disagrees about when the 40,000th day is. And this is true – Excel counts Day 40000 as July 6th 2009, not July 7th. Unfortunately for Excel users, they’re wrong. And it’s down to the fact that Excel thinks that...
    Posted to Rob Farley by Rob Farley on Sun, Jul 5 2009
    Filed under: Filed under: ,

  • Let's talk sentence-casing in Excel

    Good day, So we probably agree that Excel and/or the VBA IDE aren't the ideal locations to do your word processing, however, it's done there, either way. Both Excel and VBA (the latter being based on VB6) provide us with some tools to help, in terms of lower-casing, upper-casing, and proper-casing...
    Posted to Nate Oliver's blog by Nate Oliver on Fri, May 22 2009
    Filed under: Filed under: , ,

  • Office 2010 Technical Preview

    If you're interested in previewing Office 2010, aka 14, see the following blog-post from the Excel team: http://blogs.msdn.com/excel/archive/2009/05/12/microsoft-office-2010-technical-preview.aspx It turns out you actually register to be invited, which are limited in number, for said technical preview...
    Posted to Nate Oliver's blog by Nate Oliver on Fri, May 22 2009
    Filed under: Filed under: , , ,
Page 1 of 2 (31 items) 1 2 Next >