+ Reply to Thread
Results 1 to 2 of 2

how to edit the _rels.xml file to allow a custom image?

  1. #1
    Forum Expert GeneralDisarray's Avatar
    Join Date
    09-15-2011
    Location
    Pittsburgh, PA, USA
    MS-Off Ver
    Windows Excel 2016
    Posts
    1,416

    how to edit the _rels.xml file to allow a custom image?

    I am having trouble referencing a custom icon in a custom ribbon (instead of using a stock imageMso icon i want to use ones I've made.



    Here's what I tried

    Edited the rels file to include the relationships:

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

    <Relationship Id="myImage" Type="http://schemas.microsoft.com/office/2006/relationships/ui/extensibility" Target="customImages/myImage.png"/>


    And built the customUI.xml file to include the image in a button:

    <customUI xmlns="http://schemas.microsoft.com/office/2006/01/customui">
    <ribbon startFromScratch="false">
    <tabs>
    <tab id="CustomTab" label="ADV_Daily">
    <group id="cg1" label="SQL">
    <button id="Button1" label="Refresh Data Tables" image="myImage" size="large" onAction="Refresh_QueryTables" />
    </group >
    </tab>
    </tabs>
    </ribbon>
    </customUI>


    I've been able to make custom ribbons using the stock imageMSO options without any problem. But, when I try to include a custom image like this,I get the area in the ribbon, and the command works, but there is no image displayed.

    Am I referencing the wrong schema, saving the images in the wrong format, not including some other parameter (like size="large")... or something else??

    THank you for reading this!


    (I'm trying to follow the example here http://msdn.microsoft.com/en-us/libr...ffice.12).aspx - they indicate the image must be included in the relationship file but don't mention how to include it)
    Last edited by GeneralDisarray; 11-04-2014 at 12:57 AM.
    Remember, saying thanks only takes a second or two. Click the star icon(*) below the post you liked, to give some Rep if you think an answer deserves it.

    Please,mark your thread [SOLVED] if you received your answer.

  2. #2
    Forum Expert GeneralDisarray's Avatar
    Join Date
    09-15-2011
    Location
    Pittsburgh, PA, USA
    MS-Off Ver
    Windows Excel 2016
    Posts
    1,416

    Re: how to edit the _rels.xml file to allow a custom image?

    Found a sensible answer
    http://www.contextures.com/excelribb...tml#customicon


    The customUI.xml file needed another .rels file (relationship file) in the customUI directory in order to define where the image for the icon lived.

    If you extract the attached file (which was available from the link above) you can cruise through the directories and see what I mean.

    Pretty neat trick
    Attached Files Attached Files
    Last edited by GeneralDisarray; 11-04-2014 at 12:56 AM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 2
    Last Post: 07-02-2013, 03:36 PM
  2. Edit an Image in Excel 2010 - Possible?
    By MacroPolo in forum Excel General
    Replies: 2
    Last Post: 11-29-2012, 01:51 PM
  3. [SOLVED] Insert jpg image from file path to image frame
    By SAsplin in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 11-27-2012, 10:12 AM
  4. Opena zip file _rels etc
    By zhshqzyc in forum Excel General
    Replies: 1
    Last Post: 02-28-2011, 01:25 PM
  5. Can i Edit or Convert an Image in Word
    By Reema in forum Word Formatting & General
    Replies: 3
    Last Post: 06-30-2009, 06:51 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1