Daily Dose of Excel

Random Numbers Repeating

Daily Dose of Excel — Wed, 27 Aug 2008 16:21:38 GMT

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

Daily Dose of Excel — Mon, 25 Aug 2008 13:12:41 GMT

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

Daily Dose of Excel — Sat, 23 Aug 2008 19:44:25 GMT

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

Daily Dose of Excel — Sat, 23 Aug 2008 14:05:03 GMT

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

Daily Dose of Excel — Thu, 21 Aug 2008 21:36:11 GMT

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

Counting Olympic Medals

Daily Dose of Excel — Mon, 18 Aug 2008 01:32:16 GMT

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

Daily Dose of Excel — Fri, 15 Aug 2008 21:11:57 GMT

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

Daily Dose of Excel — Thu, 14 Aug 2008 16:00:06 GMT

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

Daily Dose of Excel — Wed, 13 Aug 2008 16:21:49 GMT

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

Daily Dose of Excel — Thu, 07 Aug 2008 19:51:50 GMT

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)

Data Visualization? Sir, Yes Sir!

Daily Dose of Excel — Mon, 04 Aug 2008 21:46:52 GMT

Did you ever want to join the army but don’t like all the physical activity? And instead of shooting people you’d rather create charts and dashboards in Excel? If so, you should go to the Excel Dashboard and Visualization Bootcamp. This 3-day boot camp is designed for Excel users who need to more effectively [...] Read More......(read more)

Increment File Names

Daily Dose of Excel — Mon, 04 Aug 2008 02:46:21 GMT

I have to save a file that may have the same name as an existing file. If it does, I append a number to the end of it to make it unique. The problem is that the file will live in three different folders in its life; Working, Review, and Archive. I [...] Read More......(read more)

The NEW Spreadsheet Page

Daily Dose of Excel — Thu, 31 Jul 2008 01:54:12 GMT

Finally, I redesigned The Spreadsheet Page. The official launch is Friday, but you can take a sneak peek if you're interested. Out with FrontPage, and in with Expression Engine. Man, that's some powerful software. The site is all database driven now, so it will be much easier to maintain and update. Feedback is welcome. If [...] Read More......(read more)

Multiple Add-ins

Daily Dose of Excel — Tue, 29 Jul 2008 21:08:43 GMT

I'm creating several add-ins that will all use the same top-level menu item. The add-ins will be installed as needed. So someone may have just one and someone else may have half a dozen. The right answer, I think, is to have one controlling add-in that handles the menus (and not much [...] Read More......(read more)

Filter by Selected Cell’s Value, Cell’s Color or Cell’s Font Color

Daily Dose of Excel — Tue, 29 Jul 2008 17:57:02 GMT

Hi all After creating and testing a lot of code to filter on normal and on Conditional Formatting colors I came up with a nice and easy solution I think. I made this page for Excel 2007 http://www.rondebruin.nl/colorfilter2007.htm Suggestions are welcome Ron de Bruin http://www.rondebruin.nl/tips.htm Read More......(read more)