Daily posts of Excel tips…and other stuff
Archive for the ‘MVP’ Category.
My previous post went a bit unnoticed, but I bet this one might interest some of the Office developers…
In that post, I showed how to access and modify existing parts of an Office OpenXML package. This opens up the path for us to add ribbon customisation code to an Office file. For this to happen, [...]
Hi Everyone!
Today I finally found time to actually post a brand new article on my website.
Wouldn’t it be useful to be able to edit the contents of an Office 2007 OpenXML file from within VBA? Well, now you can, using the sample code and explanation in this article.
Enjoy!!
Regards,
Jan Karel Pieterse
www.jkp-ads.com
Nick Hodge has been getting a lot of press lately.
First, he recently appeared on J-Walk’s blog.
More recently, he was featured on the MVP blog. I’ve been reading that MVP blog since it started and finally I know somebody. I guess I can quit reading it now. Good job, [...]
Hi everyone,
With all these Euler posts I thought, why not post my own?
Suppose the following:
I have a products table set up like this:
Code ProdName Price
0001 Product1 556.68
0002 Product2 977.41
0003 Product3 350.62
0004 Product4 509.16
0005 Product5 748.4
0006 Product6 802.96
(list goes on to as much as 5000 products)
And I want to show this table in a userform and give the user some filtering possibilities (lets say on the first two [...]
Hi all,
I’ve just published a new article on my website. Here is the introduction:
“This article explains how you can use styles to ease maintenance of your spreadsheet models.
Microsoft has made it very easy to dress up your worksheets with all sorts of fill patterns, borders and other frills. Because formatting of cells is often done [...]
A meeting of the above group will take place on Wednesday 1st and Thursday 2nd April 2009 in London. This FREE event has some fantastic speakers from the Excel community.
The agenda for the two days is outlined below and you can book for either or both days by emailing bookings@excelusergroup.org.
Microsoft will be providing the venue [...]
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 first Office [...]
Hi everyone,
Already 5 years have passed 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 [...]
