How do I export my ARM report to a word processing or spreadsheet program?

back

Print ARM reports directly to a word processor or spreadsheet program by first selecting one or more available reports in the Print Reports dialog (select File, then Print Reports). Select the "Next" button on Print Reports dialog to display the Print dialog. (You may need to select OK to close a Report Messages window.)

A. Word processor:
On the Print dialog, select “Print to Word Processor” button to create a .rtf (rich text format) document in the Print directory defined in File options. ARM then opens that document in the associated word processor program (typically Microsoft® Word) so you may view the report. The “Print to Word Processor” button is disabled if there is not a Windows file association for RTF files.

The RTF format contains the most detailed formatting information, and is best able to preserve ARM report formatting. You may also edit the RTF document to change formatting.

When the report Global Settings is set to print borders, then bordered tables in ARM reports are printed as bordered tables in the rich text document. With this technique, the report appearance in the word processor document is nearly identical to the report appearance when printed on paper from ARM. Clear the report Global Setting to print borders if ARM report tables should be printed to .RTF files as tab separated columns.

B. Microsoft® Excel spreadsheet:
On the Print dialog, select the desired print formatting of All, Quick, or None, and then select the Print to Excel button. ARM then opens Excel and directly builds one worksheet for each report in the report set. A new workbook is created if Excel is not open; otherwise the ARM report is added to a workbook that is currently open.

The formatting choice All includes all ARM formatting, including borders and font colors. It can be fairly slow to create an ARM report in Excel with All formatting, so Quick (merge cells) is the default option.

Please note that ARM does not save the Excel workbook, so you need to save the report from Excel.

 

Last Updated January 03, 2008

                                          

                        Copyright © 1997-2008 Gylling Data Management, Inc.