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.
Jan Karel Pieterse
2 thoughts on “Editing elements in an Excel OpenXML file using VBA”
Nice and useful article
On this page there is a unprotected add-in named RDBQAT
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 ?
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
Posting code? Use <pre> tags for VBA and <code> tags for inline.