-
Hi everyone,
I have had a Dutch article on XML and Excel on my site for quite some time now, but never got round to translating the thing into English.
Well, yesterday I found a bit of time during a long train-ride, so here it is:
XML And Excel
From the intro:
Microsoft Office 2003 Professional was the...
-
Hi everyone,
Already 5 years have past since I founded my company. And I must say those years passed in the blink of an eye. I’ve never enjoyed my work as much as in these past years. Even if at times things were hectic and I worked crazy hours. I’ll never start working for a boss [...]
-
Hi all,
So after Dicks (nice to read) rambling on golf, let’s do some Excel/VBA stuff again.
I intend to get a bit of discussion on this one, so bear with me.
I’m currently developing an Excel workbook for a customer. One of the interesting things with this project is that it consists of...
-
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...
-
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...
-
I’m in Seattle for the MVP Summit. This hotel is great. I just downed a whole jar of complimentary Macademia nuts and… What’s this thing that looks like a menu? Damn!
I’m off to register and score some of the Rock Bottom brew. I’ll be sure to have one for those [...]
-
Mike from the Northeast won the 4-year anniversary contest. A copy of Dalgleish’s Excel Pivot Table Recipes is soon to be rushing to his house from wherever Amazon rushes stuff. In the contest, I asked for your favorite non-Excel blogs, and here are some of them:
Office Live Small Business…...
-
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...
-
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...
-
[quote user="Nick Hodge"] Peder I'll check it out, thanks for dropping by. It's fairly new as you know ;-) I knew how to add code in standard modules, but have never added it to class ones, so thanks for the enlightenment too [/quote] Great! Yeah, I can see it's new, I picked it...