SEARCH
0-9 A B C D E F G H I J K L M N O P Q R S T U V W X Y Z
Prev | Current Page 142 | Next

Jim DeMarco

"Pro Excel 2007 VBA"

A _rels folder containing the .rels file is copied
to your folder. (If only the file appears, use your ZIP tool??™s extract function rather than
dragging the file from the ZIP window.)
4. Open the .rels file and add the following line between the last Relationship tag and
the Relationships tag, as shown in Listing 3-1. This creates a relationship between the
workbook file and the customization file.
Listing 3-1. Adding the CustomUI Relationship to the .rels. File
xmlns="http://schemas.openxmlformats.org/package/2006/relationships">
Target="docProps/app.xml" />
Target="docProps/core.xml" />
Target="xl/workbook.xml" />


5. Close and save the file.
6. Add the _rels folder back to the container file by dragging it from its location, overwriting
the existing file.
7. Rename the workbook file back to its original name.
8. Open the workbook and notice that the Ribbon UI now displays your XML data
functions.
9. Click the buttons to check that the functionality is there and working (shown in
Figure 3-32).


Pages:
130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154