Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Programming / September 2007

Tip: Looking for answers? Try searching our database.

Custom Ribbon example in Walkenbach's "Excel 2007 Power Programming with VBA"

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Greg Lovern - 16 Sep 2007 05:12 GMT
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?
Jim Rech - 16 Sep 2007 15:42 GMT
The error message says that the file extension does not match the type of
file.  The XLSM extension indicates a file in the new Excel 2007 format that
contains a VB project.  So something isn't right with the file.  Either it
doesn't have a VB project or the file is not in the new format or it is
corrupted or ... who knows.

To see an example of this name mismatch, save an empty new Excel file as a
workbook (XLSX supplied automatically by Excel).  Close it, rename it to
XLSM via Windows Explorer, and then try to open it.

If you really think it meets all the requirements I'd be happy to look at it
if you want to email it to me.

Signature

Jim

> I'm trying to do the custom ribbon example on pages 736 - 739 of John
> Walkenbach's "Excel 2007 Power Programming with VBA".
[quoted text clipped - 59 lines]
>
> Any idea what's wrong?
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.