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
Hi JK
Nice and useful article
On this page there is a unprotected add-in named RDBQAT
http://www.rondebruin.nl/imageqat.htm
See this section: Copy a customized QAT from one workbook to another(Add-in)
There is also code that is maybe useful if you want to change
things in a Office 2007 archive ?
Hi,
Well done Jan Karel. When I first heard about XML ribbon and the new “zip” file I thought this might be a way so be able to deploy both at the same time. I’m not at the stage where I really need to use it yet, but If I ever am, I will know where the solution is!!!!
Thanks to you and Ken for sharing
Ross