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

Browse by Tags

  • 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...
  • 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...
  • Random Numbers Repeating

    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...
  • The Ultimate Steal

    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...
  • Add missing built-in commands to the QAT or Ribbon

    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...
  • Change built-in groups in the Ribbon

    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...
  • Office Community Clips

    Have you seen the new Microsoft Office Community Clips? People upload videos that demonstrate how to perform a task. I guess people like this because it's almost like watching TV. Never mind that you actually have to click and watch in order to determine if it's useful. And, a 3-minute video contains roughly the same content [...] Read More...
  • Using an Analysis Template — Updating the data source

    The motivation for this quick and incomplete draft was Dick Kusleika’s post on distributing/communicating a PivotTable template (http://www.dailydoseofexcel.com/archives/2008/05/21/pivottable-markup-language/). In the approach I’ve adopted for the past few years, the basic idea is to separate the data from the analysis and presentation. Then, a simple piece of code lets one update the data connections in [...] Read More...
  • Alive and Well

    Howdy. It’s been quiet at the ol’ DDoE lately, but I thought I would check in and let you know I’m still around. I generally slow down a little in the Summer, but this Summer has been surprisingly busy. I have some nice Excel posts in the queue. In the mean [...] Read More...
  • VBE Bookmark add-in for Office 2000-2007

    Hi all New page on my site with a very useful add-in from Jim Rech. http://www.rondebruin.nl/vbebookmarks.htm VBEBookmarks.dll is a simple COM Add-in created by Jim Rech for the Microsoft Office 2000-2007 Visual Basic Editor which lets you bookmark up to five locations in VBA projects for easy navigation among them. Have fun Ron de Bruin http://www.rondebruin.nl/tips.htm Read More...
  • Can You Believe

    That I started this blog four years ago. I can’t. It seems more like six and a half. Here’s some stats: That’s about 26 posts per month and about 8 comments per day. I’m no Nick Hodge, but hey. As is my wont, I’ll be having an anniversary give-away. I just like [...] Read More...
  • Limits

    I recently ran into a problem with an application I developed over a year ago. I had pre-formatted 100 rows in a template, some just formatting, some conditional formatting. “We’ll never need 100 rows”, I said. One hundred ninety-six rows later and I feel like the Patent Commissioner who said everything has [...] Read More...
  • Excel User Conference Download

    Download Presenter Notes and Sample Files If you didn’t attend, these files will be of limited value. But there they are if you want them. As I mentioned at the conference, I will be reformatting my laptop hard drive this weekend. My folder problem that I’ve been blaming on Groove, isn’t Groove’s fault (I think), [...] Read More...
  • Conduct in Reserve

    I’m back in the good ol’ USA after traveling for 22 hours. I’m expecting a jet-lag hangover tomorrow. Today I had a 3.5 hour nap, so I’m still up at 11:30 writing a blog post. Here are some thoughts about my trip. I got more out of the conference than the delegates. [...] Read More...
  • G’day

    Here’s something you may not have known about Australia: They haven’t heard of free internet yet. This post is costs $2. You’ll have to wait until I’m stateside to hear about all the $7 beers I’ve been drinking. Update That strike through costs another $1 and this update another $1 still. What am [...] 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.