Browse by Tags

Hi everyone! Yesterday I experienced the tedious task of figuring out what the differences are between the VBA projects of two different versions of a customer project I built a long time ago. Luckily there are tools to compare differences in text files, such as ExamDiff. But the VB editor doesn’t give you an easy way to [...] Read More...

Hi all, I had a bit of time to spare the other day (got snowed in during travel by train) and wrote a couple of pages about a new Excel 2010 feature: Pivot table slicers I show how to customise them and also included some VBA examples on how to work with them. Enjoy the read! Regards, Jan Karel Pieterse www.jkp-ads.com Read More...

According to Microsoft, I’m awesome. Who am I to disagree? I’ve actually been an MVP for a few years, but the stackable acrylic award only started last year. I’m not sure when I was first awarded, but it was around the same time as Debra and Jon, so maybe they remember. There was a time [...] Read More...

In Preventing auto_open and Workbook_Open events from running I descibed how to do exactly that. Well, it appears that the methods I gave do not always work with Excel 2007. A visitor of my website complained he could not prevent his Auto_Open macro from running and during a BeamYourScreen session I took over his desktop and [...] Read More...

Hi there! Many times it is a newsgroup post which triggers me to do a writeup on a specific subject. This time, a user asked how he could import a csv file every month, without having to go through the hassle of renaming the file and re-defining the import settings each time. Opening the file in Excel [...] Read More...

Hi All, Many users (including customers of mine) have experienced trouble with two recent security updates by Microsoft, see: http://support.microsoft.com/kb/973475 and http://support.microsoft.com/kb/973593 There seem to be two hotfixes to this problem: KB973475 Excel 2003 hotfix package : http://support.microsoft.com/hotfix/KBHotfix.aspx?kbnum=978908&kbln=en-us KB973593 Excel 2007 hotfix package : http://support.microsoft.com/default.aspx?scid=kb;EN-US;978522 If you experience problems with...

As a fulltime developer I oftentimes open files containing VBA and want to be able to run code. At the same time I sometimes want to prevent Workbook_Open event code or an Auto_Open macro from running. With Excel 97 to 2003, this was simple: hold the shift key when you click “Enable macros”. With Excel 2007 and [...] Read More...

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