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.
--
Jim
"Greg Lovern" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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?
>
|
Similar Threads
