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
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