Calling CustomUI Embedded image using VBA

[rawat26]

Hi There,

I am creating a custom ribbon. I have added PNG images in my CustomUI editor. In my, Excel code I am changing Ribbon images using getImage(). I am able to change it with Office icons but not sure how to call my Embedded images.

Please help.

 

[jkpieterse]

As far as I know, you can only achieve this by opening the zip container every xlsm file is and extracting the file from there:
Excel 2007 fileformat: Editing elements in an OpenXML file using VBA
It is a lot easier to just have the icon files in the same folder as the workbook and read them from disk.
Alternatively, if there aren't too many you could put all incarnations of each button in the RibbonX and use the getVisible callback to display the right one.