Daily posts of Excel tips…and other stuff
Archive for the ‘VBA’ Category.
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 [...]
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 [...]
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, [...]
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 [...]
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 [...]
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
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 [...]
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. [...]
