Problem while trying to update an Excel 2003 Add-In to 2007

Asked By Susan A Gettus 20 points N/A Posted on - 08/21/2012

Hello,

While trying to update an Excel 2003 Add-In to 2007, I thought I finally had the hang of getting the XML code and inserted. *.PNG Icon image in the MS Office 2007 Custom UI Editor to work in conjunction with the necessary VBA code because I was able to accomplish same with a single instance of this process.

So, I continued to add a couple dozen more of these images to my *.xlam file, added the appropriate "image="" parameters to the XML, saved and closed the Editor and then opened the *.xlam file in Excel 2007.

However, I am now getting a slew of "An error occurred while loading image with relationship ID …" errors (with each specifying the name of the embedded icon file) – I believe I am getting one error for each image now in the file. All of the images are *.PNG files.

Help is not available in any form.

I appreciate any insights on what I might need to do here.

Thanks beforehand.

• Status: Open
• Question Views: 857
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: MS Powerpoint

Answered By Carl Jack 10 points N/A #150975

Problem while trying to update an Excel 2003 Add-In to 2007

When you compare your XML code with other examples, you may find that the MSOffice 2007 Custom UI Editor has assembled the image relationships in the "customUI.xml.rels" file out of order, instead of the following right way:

Putting in mind that the latter code was built entirely be the MS Office 2007 Custom UI Editor, the error you are getting could be a bug in the editor, which could have been possibly activated by your building my Ribbon button XML code first, and later on saving the *.xlam file, and after that adding the icon.png files.

Regards,

Carl

About Carl Jack

Questions
1

Answers
1657

Best Answers
417

• Vote Up 0 Vote Down

• Posted on - 08/21/2012
• Question Category: MS Powerpoint