Archive for the ‘VBA’ Category.

Quick PivotTables

Sometime in the mid-1990s, a man named Lyle Lanley walked into Microsoft with an idea. Probably the greatest.... Oh, it's more of an Apple idea. "Just tell us the idea and we'll implement it", said Bill Gates.
I'm on a quest to rid my life of wizards. The wizards that Microsoft seems [...]

Entering Dates Into Cells Part II

I'm sure you all remember Entering Dates Into Cells from five years ago. It was a simpler time. Brittney Spears was telling us about her prerogative, the Olympics returned to Athens, and my date entering needs reflected the simplicity of the times. Now I need more.
Here are some things I discovered about [...]

Adding RibbonX code to an Office OpenXML file using VBA

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

Excel Dashboard and Visualization Boot Camp

 The second Excel Dashboard and Visualization Boot Camp takes place Wednesday through Friday of next week, May 20-22, 2009, in Frisco, Texas. There are a few spots remaining, and it's not too late to sign up.
Excel MVPs Mike Alexander and Jon Peltier are teaming up for a repeat of last October's successful boot camp. Join [...]

Zip Activeworkbook, Folder, File or Files with 7-Zip (VBA)

Hi all
I upload a new page today with code to create Zip files with the free Zip program 7-zip.
This program is also very useful if you want to open Office 2007 files as a archive
without changing the extension to .zip so you can see/edit the files in the archive.
Zip Activeworkbook, Folder, File or Files with [...]

Editing elements in an Excel OpenXML file using VBA

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

Finding External Links in Data Validation

I kept getting the Edit Links message when I opened this on particular file, but I could never find the link. It wasn't in any formulas or range names. I ended up copying each cell to a new worksheet and seeing when that new worksheet got the link. Fortunately it was about [...]

Related Sheets Stack

In Previous Sheets Stack, I created a historical list of sheets visited on the right click menu for easier navigation. After reading the comments, I decided to change the whole approach. Now I show related sheets (which I define) in a userform.
Related Sheets
I'm dealing with inventory assemblies, so the relationship is already defined. [...]