Daily Dose of Excel

The Ultimate List of Excel RSS Feeds

2008-09-08T02:24:44Z

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......(read more)

The Life of a Lion Tamer

2008-09-05T21:14:55Z

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......(read more)

Task Recorder Version1

2008-09-02T17:19:19Z

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......(read more)

Twittering Away the Day

2008-08-30T01:21:00Z

The twitter experiment is now over. I used Tweetake to get my tweets into a CSV, which I then opened in Excel. I tried to post every 1/2 hour. At the time of the post, I’d write what I did since the last post. Since I usually did more than one thing, I [...] Read More......(read more)

User Initials in Excel

2008-08-28T21:27:39Z

In Excel, you can get the Username by using Application.UserName. The Username is what is entered on the General tab of Tools > Options. Inexplicably, you cannot get the user's initials, but you can in some other Office programs. I read a suggestion to automate Publisher and get the user initials via [...] Read More......(read more)

Random Numbers Repeating

2008-08-27T16:21:38Z

I write some data to an Access database, after which I retrieve the Autonumber that Access generates. Prior to writing the data, it sits in a class and all of the classes sit in a collection. The collection needs a unique string for each entry, so I create one until I can the [...] Read More......(read more)

Twitter

2008-08-25T13:12:41Z

I signed up for Twitter a couple of months ago, made a few posts, and pretty much abandoned it. If you’re not familiar with it, Twitter is a micro-blog. You make posts of 140 characters or less. I don’t follow many people and I’m not sure what value this whole idea has. [...] Read More......(read more)

The Ultimate Steal

2008-08-23T19:44:25Z

Hi all Great tip: Thanks to Dave Peterson For the student (or families with students): http://www.microsoft.com/student/discounts/theultimatesteal-us/default.aspx Ron de Bruin http://www.rondebruin.nl/tips.htm Read More......(read more)

Add missing built-in commands to the QAT or Ribbon

2008-08-23T14:05:03Z

Hi all I add this page to my site last week with a few examples to add missing controls to the Quick Access Toolbar or Ribbon. http://www.rondebruin.nl/notinribbon.htm I am curious which missing built-in commands the readers of this blog have add to the QAT or Ribbon. Tip: John WalkenBach posted a add-in for the speech controls on his site this [...] Read More......(read more)

Retirement Calculator

2008-08-21T21:36:11Z

Download 401kalculator.xls.zip Unprotect the sheet (no password) and unhide some columns to see the calculations. Read More......(read more)

Counting Olympic Medals

2008-08-18T01:32:16Z

I saw this article in the LA Times about measuring Olympic Medals per capita. I like the idea, but I also think figuring in the GDP of the country makes sense. The US could throw a lot of money at an individual event and probably fair pretty well. I got the GDP via Wikipedia [...] Read More......(read more)

My Coding Technique

2008-08-15T21:11:57Z

Dick has been kind enough to allow me to mirror posts from DDoE, but gets little back. Therefore as a guest poster I thought I would post some ramblings I made today on excel user group regarding my own particular coding techniques. (It also allows him the weekend off) I have recently been doing most of [...] Read More......(read more)

My Places on File Dialogs

2008-08-14T16:00:06Z

On the left side of the File Open dialog (and the File Save dialog), there is an area called My Places. My Recent Documents, Desktop, My Documents, My Computer, and My Network Places must be the default, because I’m sure I’ve never added or deleted anything from this list. Recently, Bob Phillips alerted me to [...] Read More......(read more)

ShortcutText on Menu Items

2008-08-13T16:21:49Z

CommandBarButtons have a ShortcutText property that you can use to list a command's shortcut next to its menu item. The Cut menu item has Ctrl+X listed next to it. In this example, I make a new menu with one item under it. OnKey is used to assign a keyboard shortcut and the ShortcutText property [...] Read More......(read more)

Change built-in groups in the Ribbon

2008-08-07T19:51:50Z

Hi all It is not possible to add to or remove controls from built-in groups in the Ribbon. For example, the Format Painter button from the Home tab’s Clipboard group cannot be removed from this group. But there is a way around this restriction. We can hide a built-in group and then duplicate it with RibbonX. And then we can [...] Read More......(read more)