-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
I’m giving a 90-minute presentation next week entitled Tips & Tricks. I’m not much of a tips guy as I prefer deeper discussions. However, tips presentations simply can’t beat because they allow me to combine disparate items. Nobody would care if I jumped from keyboard navigation...
-
Hi all
When you open your Excel 97-2003 file in Excel 2007, one that creates its own menus,
the first thing you notice is that you don’t see your menus. Where’d they go? Then you discover
them - shunted over on the Add-ins tab. Not exactly the ideal user interface.
How are your users going...