Thanks Bill. I'll keep that in my notes. I know it will be a great dial of trial and error, but to save the operator from doing 100 individual Excel cleanups, I'm sure they'll say it will be worth it!
So you're saying that although it might take a while, I should be able to get a report with headers, break headers and totals, to be able to come into an Excel spreadsheet without losing formatting or data? Karen > It will take a little trial and error to get everything to line up and > format correctly, but there's always (from the Help screen, highlights of > important options mine): > > > PRINT Invoice WHERE CustID = 127 + > OPTION XLS + > |FILENAME Invoice.XLS + > |SHOW_CANCEL_DIALOG OFF + > |ALL_TEXT_IN_GENERAL_FORMAT OFF + > |CELL_ATTR ON + > |INCLUDE_IMAGES OFF + > |INCLUDE_LINES OFF + > |INCLUDE_RICH_TEXT ON + > |RICHTEXT_ENCODING_TYPE IMAGE + > |INCLUDE_SHAPES OFF + > |LINE_SPACE ACTUAL + > |ONE_SHEET_PER_PAGE ON + > |OPEN ON > > > >
