CustomUI injection about vba-ide-code-export HOT 4 CLOSED

I'll take a look at this later @mattpalermo

I have been thinking about taking the turn the binary I to a zip, extracting the files manipulate the XML then pack it back up and change the extension back to what it was previously.

You commented on my testing of adding excel XML that it's not a very human readable for diffing so I'm assuming you're aware of this method already.

from vba-ide-code-export.

Yes I have already played around with this idea before but I didn't find it useful. As I mentioned in my comment on one of your commits, the OoXmlUnpack tool does a really good job of this. If you want, have a play with it and see if you can discover something. But if you want to manipulate a OoXml file, it may be helpful to use a library such as the Open XML SDK, ApachePOI or Openpyxl. These library provide a higher level abstraction for creating and modifying OoXml files. All these methods may be valid ways of injecting CustomUI.xml, however I found that there is a simple function in VBA that could achieve the objective: SetCustomUI.

from vba-ide-code-export.

It appears that the function that I found is not available in Excel and this may not be possible inside the VBA environment. The alternative is to either use existing methods or make a command line program that uses one of the libraries that I mentioned above to inject the CustomUI.xml into the Excel file.

http://stackoverflow.com/questions/16264003/is-there-an-alternative-to-projects-setcustomui-for-excel
http://stackoverflow.com/questions/8850836/how-to-add-a-custom-ribbon-tab-using-vba

from vba-ide-code-export.

I'll take a look one day and use something like the in the comments I have made here:

If you want to create an Excel custom ribbon from scratch and you're not using the CustomUI editor you will need to add the following line to the .rels file in the _rels folder

<Relationship Id="someID" Type="http://schemas.microsoft.com/office/2006/relationships/ui/extensibility" Target="customUI/customUI.xml"/>

from vba-ide-code-export.