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

September 2008 - Daily Dose of Excel

Sort by: Most Recent | Most Viewed | Most Commented

  • Update

    Sorry no Excel posts lately. I thought I’d give you a quick update on what’s happening. The Texas trip was canceled due to Hurricane Ike. If I had flown Frontier I could change my ticket for nothing. Instead, American Airlines is going to charge me $175. I honestly don’t know how these [...] Read More...
    Filed under:

  • When Is Friday

    I'm working on some VBA to take some of the drudgery out of payroll. Public Function ThisFriday() As Date         ThisFriday = Date + 8 - Weekday(Date, vbFriday)     End Function   Public Function LastFriday() As Date         LastFriday = Date + 1 - Weekday(Date, vbFriday)     End Function I thought I needed to know [...] Read More...

  • Testing VBA Code

    For years I’ve wanted to make my testing easier and more automatic. My procrastination may have paid off. Version Control for Excel Workbooks Read More...
    Filed under:

  • Three Things

    Thing the first: Today I leave for Austin, Texas for golf and to watch UT v. Arkansas. There is some doubt about the latter (and some doubt about which day I’ll be coming home) because a certain hurricane is going to give Texas the Tina treatment. Thing the second: Jon Peltier said he [...] Read More...
    Filed under:

  • The Ultimate List of Excel RSS Feeds

    Do you read blogs in an RSS reader? If so, I've compiled the ultimate list of Excel RSS feeds. Currently, it's a list of 29 Excel-related blogs that have RSS feeds. To save you the trouble of subscribing, there's also an OPML file that you can download and import into your RSS reader to create [...] Read More...
    Filed under:

  • The Life of a Lion Tamer

    I know you guys have been immensely interested in how I spend my day (here and here and here). I pivoted the data from my TaskIt worksheet for this week and here it is. I think I’ll turn that into an add-in that creates the pivot table automatically and has a couple of [...] Read More...
    Filed under:

  • Task Recorder Version1

    I’ve made my first iteration of a program to record my tasks (genesis here). J-walk suggested: Create a bunch of general work-oriented categories. Then, when the timer goes off, have XL display a Userform that lets you allocate the last hour by percent in each category. Even if you’re away from your desk when the timer goes [...] 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.