Addin Doesn't Work: URLs Changed?

C

Christopher King

I am unable to customize the ribbon in Office 2007 B2TR. I suspect the
problem is some web addresses have changed. Here's what I've done.

I'm following the directions given in
http://msdn2.microsoft.com/en-us/li...rdevelopers_usingcomaddinstomodifytheribbonui.
That was written in June, 2006. I've created the folder containing
customui.xml. Its contents follow (notice the web address in the first line).
<customUI xmlns="http://schemas.microsoft.com/office/2006/01/customui">
<ribbon>
<tabs>
<tab id="CustomTab" label="My Tab">
<group id="SampleGroup" label="Sample Group">
<button id="Button" label="Insert Company Name" size="large"
onAction="InsertCompanyName" />
</group>
</tab>
</tabs>
</ribbon>
</customUI>

In Excel, I create a .xlsm file, save it, add ".zip", and add the last
relationship. Notice that the added relatonship has a different web address
than the others. Here are the contents of that file:
<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<Relationships
xmlns="http://schemas.openxmlformats.org/package/2006/relationships">
<Relationship Id="rId3"
Type="http://schemas.openxmlformats.org/officeDocument/2006/relationships/extended-properties" Target="docProps/app.xml"/>
<Relationship Id="rId2"
Type="http://schemas.openxmlformats.org/package/2006/relationships/metadata/core-properties" Target="docProps/core.xml"/>
<Relationship Id="rId1"
Type="http://schemas.openxmlformats.org/officeDocument/2006/relationships/officeDocument" Target="xl/workbook.xml"/>
<Relationship Id="someID"
Type="http://schemas.microsoft.com/office/2006/relationships/ui/extensibility" Target="customUI/customUI.xml" />
</Relationships>
Then I remove the .zip, and open the file in Excel.

I get "Custom UI Runtime Error in File" on opening the file:
Unknown Namespace: http://schemas.microsoft.com/office/2006/xmlPackage
Element: package
That is followed by:
Type '{http://purl.org/dc/terms/}W3CDTF' is not found in Schema.
That error appears twice. Finally,
"The node is neither valid nor invalid becasue no DTD/Schema declaration
was found."

As I said, I suspect the problem is that the web addresses have changed
since June, 2006. Anyone know what it takes to make this work?
Chris
 
X

XL-Dennis

Hi Christopher,

I'm not able to give You any guidelines but two things comes to my mind:

# Make a visit at Patrick Schmid's blog:
http://pschmid.net/

# Keep in mind that B2TR is a beta version and therefore there will be
changes without any further information. MSFT do a great work but the
documentation is not always updated due to the high speed.

---------------
With kind regards,
Dennis
Weekly Blog .NET & Excel: http://xldennis.wordpress.com/
My English site: http://www.excelkb.com/default.aspx
My Swedish site: http://www.xldennis.com/
 
C

Christopher King

I found the problem. The customui.xml file was supposed to be a text file.
I had saved it (blush) using Word's "Save As...", which includes a ".xml"
option. Of course, that added a lot of other stuff to the file. Saved as a
text file, things work as expected.
Chris
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top