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.



Jan Karel Pieterse

Posted in Uncategorized

2 thoughts on “Editing elements in an Excel OpenXML file using VBA

  1. 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

Posting code? Use <pre> tags for VBA and <code> tags for inline.

Leave a Reply

Your email address will not be published.