Browse by Tags

Excel Sample Data

I love finding big Excel tables, mostly because I hate manually creating sample data for testing. I’ve written about Contextures Sample Data. Then there’s the IRS Tax Statistics page that has many downloadable Excel files. The IRS tables aren’t always clean tables. Sometimes they are over-formatted, but they still work. My latest [...] Read More...

Published Thu, Jan 01 2009 11:26 AM by Daily Dose of Excel

Filed under: Downloads

Table Tools in Excel 2007

Hi all This week I create a small Add-in to add a few options to the contextual Table Tools tab. This is a start and love to have feedback what you miss or like to see in a add-in like this. This are now the options in the Add-in 1) Turn AutoFilter On or Off 2) Clear Filter of the [...] Read More...

Published Fri, Nov 11 2008 1:43 PM by Daily Dose of Excel

Filed under: General, Excel12, Downloads

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...

Published Tue, Sep 09 2008 1:19 PM by Daily Dose of Excel

Filed under: Downloads, Application Object

Retirement Calculator

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

Published Thu, Aug 08 2008 5:36 PM by Daily Dose of Excel

Filed under: Downloads

Fixing Links To UDF’s in Addins

Hi All, Excel has a host of built-in functions to help you do your computations. But sometimes you need to write your own functions using VBA. These functions are called “User Defined Functions” (UDF). UDF’s typically are placed in addins. As long as the addin is installed, the UDF’s work as expected. You get into trouble [...] Read More...

Published Mon, Jun 06 2008 1:45 PM by Daily Dose of Excel

Filed under: VBA, MVP, Downloads, Add-ins, User Defined Functions

Showing An Array On A Form; Autosizing ColumnWidths Of A ListBox

Hi all, For a project I needed a quick way to display the content of an array to the user. I didn’t want to use a worksheet, but opted for a userform. The data I wanted to show was contained in an array. The array contained something like: Description Before After Cell Errors 100 10 Corrupt Names 1000 0 Unused styles 232 0 So I figured I’d put a [...] Read More...

Published Wed, May 05 2008 1:39 PM by Daily Dose of Excel

Filed under: VBA Advanced, VBA, MVP, Downloads, User Interface, Userforms and Controls

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...

Published Mon, Apr 04 2008 3:44 PM by Daily Dose of Excel

Filed under: General, VBA, Downloads

Two popular tools updated.

Hi All, As many of you know I give away a number of tools for Excel through my site www.jkp-ads.com. Today I have updated the two most popular downloads: Name Manager (which I created together with Charles Williams, www.decisionmodels.com): Most important change: the unused names filter now includes objects in its search, as well as VBA code. It [...] Read More...

Published Fri, Mar 03 2008 3:03 PM by Daily Dose of Excel

Filed under: Links, MVP, Downloads, Add-ins, Miscellany, Names, Finding Data

Bogus Compile Errors

Hi all, Let me start this post with a shameless plug: Charles Williams and I developed Name Manager. From my website alone this tool is good for about 60 downloads a day. Just a couple of weeks ago, all of a sudden Charles and I started receiving complaints about compile errors, which neither of us could reproduce. [...] Read More...

Published Mon, Feb 02 2008 1:08 PM by Daily Dose of Excel

Filed under: MVP, Downloads, Add-ins, Miscellany

Dealing with Ribbons and Menus - Avoiding Two Versions

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 to [...] Read More...

Published Thu, Jan 01 2008 2:01 PM by Daily Dose of Excel

Filed under: General, Excel12, CommandBars, Downloads

Catching Paste Operations

You know the situation: You have carefully setup a workbook with intricate Validation schemes. But then along comes your user and he copies and pastes at will. Result: Validation zapped, workbook structure violated. What to do? The only way I find to be reliable is to catch all possible paste operations. But this isn't very easy, [...]

Published Mon, Dec 12 2007 2:27 PM by Daily Dose of Excel

Filed under: Classes, CommandBars, Collections, Copy and Paste, VBA, MVP, Events, Data Validation, Downloads

ExcelRefTool; A New Formula Auditing Tool

Hi, A while ago I requested beta testers for a new utility, now called "ExcelRefTool". Thanks to my beta testers, the tool is now mature enough to be exposed to the general public. Have a look here, download the demo if you like and give it a spin. And thanks again, to everyone who took the trouble of beta [...]

Published Mon, Dec 12 2007 8:53 AM by Daily Dose of Excel

Filed under: General, MVP, Downloads, Formulas, COM Addins, Add-ins

Copy a customized QAT from one workbook to another (Add-in)

Hi all I create a small Excel add-in to copy a customized QAT from one workbook to another. http://www.rondebruin.nl/imageqat.htm#QAT Because it not use very common code I like to hear from you if you have problems or if there are there better ways to do it ? I hope a few of you can test it for me. You can find [...]

Published Thu, Nov 11 2007 4:36 PM by Daily Dose of Excel

Filed under: General, Excel12, Downloads, User Interface

Syndication

Recent Posts

Tags

News

Archives