Running the Spreadsheet Converter
To start the Spreadsheet Converter on Excel 2007 and later
- Start Microsoft Excel.
Perform one of the following actions:
- Click the Office button in the top left corner of the Excel window, select Open, and locate the Spreadsheet Converter.
- Double-click the CX98SSCX.XLA file in Explorer or File Manager.
Next, continue with the following procedures.
To execute the Spreadsheet Converter
- After the Spreadsheet Converter is loaded, begin execution by selecting the BMC Software toolbar from the View menu item (Excel 2003 and earlier) or the Add-ins menu (Excel 2007 and later).
When you select Instructions, the BMC Software Spreadsheet Converter instruction screen is displayed.
When you select Click Here, the Spreadsheet Converter displays a list of the files that you downloaded to your PC.
When you select a report, the Spreadsheet Converter:
- creates a new workbook in which to store the results of the conversion
- automatically converts the reports in the file you select
When the file contents have been converted, the Conversion Log is displayed.
The Conversion Log is the last page in the workbook. The Conversion Log lists reports found in the input along with a description of how each one was processed. Any error messages produced during processing are also listed on this page. Additional information about any error messages you see can be displayed by selecting column 1 (hidden behind column 2).
Double-click the mouse to completely display column 1. If any symbols were defined in a report, the names of the ranges defined can be found by expanding the outline (using the controls found in the left margin).The Spreadsheet Converter can be invoked from Excel macros written in VBA, by coding a statement such as
Application.Run 'cx98sscx!Main', 'C:/Test/CMFRep.txt', 'Test.xls'where the two optional parameters are the file to be converted, and the name to be given to the resulting created workbook.