<div>
I had made a mistake when zipping up the parts of the OpenXML package, but 'The_Barman' helped trigger my finding the issue.
</div>


I had made a mistake when zipping up the parts of the OpenXML package, but 'The_Barman' helped trigger my finding the issue.

<div>
<div class="content wysiwyg-content">
I have a lot of experience creating new ribbons to enhance the presentation of my Excel applications. I usually use the OpenXMLDeveloper 'Custom UI' tool (<a href="http://openxmldeveloper.org/blog/b/openxmldeveloper/archive/2006/05/25/customuieditor.aspx" rel="ugc">Click here</a>). I am soon going to be working on a project were I will not be able to install the editor and so am looking at manually updating the 'CustomUI14.xml' file that contains the Ribbon XML.<br />
<br />
I know of the internal file structure of the XLSX and XLSM files but the problem I am getting is that when I re-zip (with or without compression) the folder of the XML parts and try to open the file in Excel, I get the following 'Corrupt' error message. I am therefore unable to open the files I manually edit.<br />
<br />
<a href="https://filedb.experts-exchange.com/incoming/2013/09_w37/676946/2013-09-12-11-40-36-Microsoft-Ex.jpg" target="_blank" title="Error message : The file is 'corrupt' (21 KB)"><img alt="Error message : The file is 'corrupt'" class="file-block lazyload" style="max-width: 800px;" data-src="https://filedb.experts-exchange.com/incoming/2013/09_w37/800_676946/2013-09-12-11-40-36-Microsoft-Ex.jpg" /></a><br />
Can anyone explain / suggest why ?
</div>
</div>


2013-09-12-11-40-36-Microsoft-Ex.jpg

I have a lot of experience creating new ribbons to enhance the presentation of my Excel applications. I usually use the OpenXMLDeveloper 'Custom UI' tool (Click here (http://openxmldeveloper.org/blog/b/openxmldeveloper/archive/2006/05/25/customuieditor.aspx)). I am soon going to be working on a project were I will not be able to install the editor and so am looking at manually updating the 'CustomUI14.xml' file that contains the Ribbon XML.

I know of the internal file structure of the XLSX and XLSM files but the problem I am getting is that when I re-zip (with or without compression) the folder of the XML parts and try to open the file in Excel, I get the following 'Corrupt' error message. I am therefore unable to open the files I manually edit.



Can anyone explain / suggest why ?

Manually edit Excel RibbonX customisation

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.

Microsoft Office

Extensible Markup Language (XML) refers to the encoding of documents such that they can be read by both machines and humans. XML documents use tags to show the beginning and end of a set of data. XML is used extensively on websites to show volumes of data, and is the default for a number of office productivity suites. This topic includes discussions of XML-related technologies, such as XQuery (the XML Query language), XPath (the XML Path language), XSLT (eXtensible Stylesheet Language Transformations), XLink (the XML Linking language) and XPointer (the XML Pointer language).