...
Click the Add New Location button, and add the file location where the utility (Excel file) will be stored.
Also, you may wish to disable the "/" key as an Excel menu option. In Options | Advanced | Lotus Compatibility, clear the "Microsoft Excel menu key" property. This will allow you to type XPath queries starting with "/" in a worksheet cell.
Test the ability to run macros by clicking the ">> Go to Setup" button on the About sheet.
Other Utilities
In addition to the ACE Configuration Management Utility and the ACE Configuration Editor software, the following utilities are also recommended for help in designing the XPath queries used in the utility:
A good text editor, such as Notepad++, to view XML files. (This will help by showing the XML structure of the configuration.)
A good text diff program, such as WinMerge, to view differences between the original and modified XML files. (This is useful when designing the XPath queries, to ensure that XML changes are made as intended.)
...
...
Setup Sheet
On the About page, click the ">>Go to Setup" button. Or click on the tab for the Setup sheet. Make the following settings:
...
NOTE: If you use the same Output XML Path as the source Configuration Path and no Output File Suffix then the output file will overwrite the original configuration! This is not recommended.
...
After setting up the paths, filter, and file suffix, click the "> List Configurations <" button. This will generate a list of configuration names based on the above criteria.
...
The Configurations sheet lists the names and descriptions of XML configuration files that will be queried or modified by this utility. Only ACE XML configurations (with a TemplateProperties/Description XML field) will be included automatically. You can click on the tab for the Configurations sheet at any time, or click the ">> Go to Configurations" button.
After clicking the "> List Configurations <" button on the Setup sheet, you will automatically be taken to the Configurations sheet. You can click on the tab for the Configurations sheet at any time, or click the ">> Go to Configurations" button.
...
On the Configurations sheet, there are three columns:
...
Query rows must begin on the row immediately below the "Column Header" row.
After defining the Select Query, click the "> Query Configurations <" button. This will run the listed Query definitions for each configuration on the Configurations sheet that has a "1" in the Include column.
The results of all queries for all configurations will be stored on the Query Results sheet.
...
Query definitions consist of 4 columns, with one Query definition per row:
...
The Column Header, Description, Select Query, and Condition Query columns serve the same purpose as on the Query sheet, when used as a simple query (no Modify action). When a “Mod Type” action is selected, the Select Query chooses one or more nodes (or parents of nodes) in the XML document, at which point the action will be performed (such as modifying a value, adding a child node, or removing a node).
...
Column Header
The Column Header defines one or more columns of data to be stored on the Modify Results sheet. The Column Header is just descriptive, but does need to be non-blank.
...