LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 224
Default Custom Ribbon example in Walkenbach's "Excel 2007 Power Programming with VBA"

I'm trying to do the custom ribbon example on pages 736 - 739 of John
Walkenbach's "Excel 2007 Power Programming with VBA".

I haven't been able to get the example files that should have been on
the cd (the cd just has a file that says it wasn't ready). So I'm
walking throught it manually. I'm getting the error "Excel cannot open
the file 'Excel 2007 Custom Ribbon Example.xlsm' because the file
format or file extension is not valid. Verify that the file has not
been corrupted and that the file extension matches the file format of
the file."

I've tried it with two new workbooks; same problem with both.

I do have "Show Add-In User Interface Errors" turned on.


Here's the VBA module text:

Sub CustomRibbonExample(control As IRibbonControl)
MsgBox "ok"
End Sub


Here's the customUI.xml:

<customUI xmlns="http://schemas.microsoft.com/office/2006/01/
customui"
<ribbon
<tabs
<tab idMso="TabData"
<group id="Group1" label="Custom"
<button id="Button1"
label="Custom Ribbon Example"
size="normal"
onAction="CustomRibbonExample"
imageMso="HappyFace" /
</group
</tab
</tabs
</ribbon
</customUI


Here's what I added to the .rels:

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


And here's the whole .rels:

<?xml version="1.0" encoding="UTF-8" standalone="yes"?
<Relationship Type="http://schemas.microsoft.com/office/2006/
relationships/ui/extensibility" Target="/customUI/customUI.xml"
Id="12335" /
<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"/</
Relationships


Any idea what's wrong?

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Selecting "Save As" adds "Copy of" to file name- MS Excel 2007 ronhansen Excel Discussion (Misc queries) 1 November 15th 09 09:33 PM
In Excel 2007, can you add "custom" formats to number format dropd Robin B! Setting up and Configuration of Excel 1 August 21st 09 09:31 PM
how i convert "100" to "hundred"( number to text) in excel-2007 mohanraj Excel Worksheet Functions 1 May 11th 08 09:07 PM
"Excel 2003 Power Programming With VBA" John Walkenbach - pls share al007 Excel Programming 1 January 7th 06 05:13 PM
how do you type squares or "to the power" in excel?? Hyperyoda Excel Discussion (Misc queries) 4 December 3rd 05 09:57 PM


All times are GMT +1. The time now is 09:47 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"