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

February 2008 - Daily Dose of Excel

Sort by: Most Recent | Most Viewed | Most Commented

  • Fixed Width Text Files

    Recently, I had to submit a fixed width text file to a state tax agency in lieu of sending them physical copies of W-2 forms. Fixed width files contain a number of columns and each column starts at a particular position on the line. If the data in that column is shorter than [...] Read More...
    Filed under:

  • Using the Object Browser

    Mathew asks: Where do you find the field names for Outlook, i.e. FirstName. Yours are practically about the only ones I can get to work. Strangely, I can’t get Business Phone (s) or faxes to work. The answer: Use the object browser. Here’s how. First, make sure you have a reference set to the Outlook [...] Read More...
    Filed under:

  • Presidents Day Chart Sale

    Worst. Blog title. Ever. Jon Peltier of Peltier Technical Services (and world renowned charting expert) has started the PTS blog to: …show off some of the projects I’ve worked on, share some Excel and Charting tips and techniques, show how to make some tricky charts that people ask about in forums and newsgroups, and talk about the [...] Read More...
    Filed under:

  • New Excel for Old Guys

    As I mentioned in a recent post, I’ve finally installed Excel 2007 (Office Ultimate, actually) on my home computer. I had it on a virtual machine back when it was in beta, but now it lives as a first-class citizen on my hard drive right next to Office 2000, Office XP, and Office 2003. I’m [...] Read More...
    Filed under:

  • Steady vs. Volatile

    I read my retirement account statement today. It wasn’t pretty. A lot of low, single digit returns lately. I know people who complain when the market tanks, but I’m not one of them. When it comes to my retirement, I want the market to keep going down until I’m 59 1/2, [...] Read More...
    Filed under:

  • MSDN Primers

    MSDN has some nice articles on the basics The Application Object The Range Object Read More...
    Filed under:

  • G’Day Excel

    Hey, if you’re within 5,000 miles of Sydney, Australia next month, be sure to sign up for the Excel User Conference. Australian Excel User Conference I’ll be presenting some of the sessions and I’m pretty excited about that. I’m less excited about spending 18 hours in coach, but at least I’ll finish that book I started [...] Read More...
    Filed under: ,

  • Bogus Compile Errors

    Hi all, Let me start this post with a shameless plug: Charles Williams and I developed Name Manager. From my website alone this tool is good for about 60 downloads a day. Just a couple of weeks ago, all of a sudden Charles and I started receiving complaints about compile errors, which neither of us could reproduce. [...] Read More...
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.