Excel User Group
Microsoft Excel blogs, forums, files. Read, ask questions, provide answers.

October 2008 - Daily Dose of Excel

Sort by: Most Recent | Most Viewed | Most Commented

  • My First Ribbon

    Without further ado: <customui xmlns="http://schemas.microsoft.com/office/2006/01/customui">     <ribbon>         <tabs>             <tab idMso="TabHome">                 <group idMso="GroupClipboard" visible="false" />             </tab>         </tabs>...
    Filed under:

  • Disable Excel 2003 Menu Accelerators keys in Excel 2007

    Hi all If you create a dictator application in Excel 2007 you maybe want to disable the shortcuts to the old Excel 2003 menu items in Excel 2007. I create this page with example code to do this. Note: There is no test on this moment to see if a tag is already used. http://www.rondebruin.nl/acceleratorskeys.htm If you want to have a [...] Read More...
    Filed under:

  • Free Financial Advice

    At some point in the future, we’re going to look back at the stock market during this financial crisis. If we take a broad enough view, we’ll see something like this: If you move your long-term common stock investments into money market accounts (basically cash) now, you’ll probably be doing it at the worst time [...] Read More...
    Filed under:

  • Automated Formulas Testing

    When I test formulas on a spreadsheet, it s a very manual process. I'm trying to figure out a way to automate this. Here's what I have so far. I want to identify some input cells and output cells. Then record some known good values for the inputs and outputs and store them. [...] Read More...
    Filed under: ,

  • Handling Delimeters in CSV Files

    When rolling your own csv files, you have to account for commas in the text. Extra commas will create extra columns and you don't want that. Let's start with this data: Two of the names have commas and two don't. By ignoring those commas, extra columns are created because a comma delimits a [...] Read More...
    Filed under:

  • Excel in the News

    When Excel is in the news, it’s never a good thing. via Above The Law According to the various affidavits (posted below) the Cleary first-year did not notice that the 179 contracts were marked as “hidden” in Excel, and certainly didn’t notice that those entries became “un-hidden” when he globally reformatted the document. If you’re buying any troubled [...] Read More...
    Filed under:

  • Identifying Sheets

    I ran into a little problem with Excel 2007 this week. When I have an Excel 2003 add-in loaded in 2007, it exhibits some strange behavior when copying sheets. Namely, in certain circumstances the CodeName property of the sheet gets changed. I'm not sure what all those circumstances are, but I do [...] Read More...
    Filed under: ,

  • Range within a Range

    I recieved this email from my pal Simon: “One of the problems in many of the spreadsheets and potential spreadsheets I come across is the need to automatically adjust to changing areas of external data. It seems at first glance that, to refer to a single column in a block of external data, the intersection operator [...] Read More...
    Filed under:

  • Star Rating Number Format

    It’s Wednesday night. That means I’m drinking Tangueray and reviewing football games (for entertainment purposes only). I like to rate games on a three-star system. Three stars means refinance the house and fly to Vegas. Two stars means I really like a team. And one star means I’d have as [...] Read More...
    Filed under:

  • Three Porting Issues

    I'm porting an application to Excel 2007 and thought I'd share some problems I've run into. First, there's FileSearch. I use FileSearch to read CustomDocumentProperties from closed Excel files. That way I can determine if the file is a part of my app and relevant to the context before I open it [...] Read More...
    Filed under: ,
Copyright Excel User Group and the relevant contributors, 2008. All Trade Marks acknowledged. This site is a peer-to-peer site and NOT affiliated in any way to Microsoft Corp. All rights reserved.