Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Custom Ribbon example in Walkenbach's "Excel 2007 Power Programming with VBA"
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" wrote in message oups.com... 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Selecting "Save As" adds "Copy of" to file name- MS Excel 2007 | Excel Discussion (Misc queries) | |||
In Excel 2007, can you add "custom" formats to number format dropd | Setting up and Configuration of Excel | |||
how i convert "100" to "hundred"( number to text) in excel-2007 | Excel Worksheet Functions | |||
"Excel 2003 Power Programming With VBA" John Walkenbach - pls share | Excel Programming | |||
how do you type squares or "to the power" in excel?? | Excel Discussion (Misc queries) |