At 10:49 PM 8/17/2011, Bill Niehaus wrote:
Is there a way to have the file compatible with Excel 97-2003 Workbook?
We are using the files on a handheld data recorder that uses Documents
to Go and need to convert them to Excel 97 with Excel.
Bill,
Using R:BASE eXtreme 9.1, try the "XLSW" option to create output file as
MS Excel Workbook, and see what you get.
-- Example 01:
-- Print Single Invoice as Workbook (Sheet1)
CONNECT RRBYW17
PRINT Invoice WHERE TransID = 1001 +
OPTION XLSW +
|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 +
|SHEET_INDEX 1 +
|OPEN ON
RETURN
-- Example 02
-- Print Multiple Invoices as Workbook (Each Invoice as separate Sheet)
CONNECT RRBYW17
PRINT Invoice WHERE CustID = 127 +
OPTION XLSW +
|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
RETURN
Should you have further questions, or need more examples, please feel
free to contact me privately.
Very Best R:egards,
Razzak.
--- RBASE-L
================================================
TO POST A MESSAGE TO ALL MEMBERS:
Send a plain text email to [email protected]
(Don't use any of these words as your Subject:
INTRO, SUBSCRIBE, UNSUBSCRIBE, SEARCH,
REMOVE, SUSPEND, RESUME, DIGEST, RESEND, HELP)
================================================
TO SEE MESSAGE POSTING GUIDELINES:
Send a plain text email to [email protected]
In the message SUBJECT, put just one word: INTRO
================================================
TO UNSUBSCRIBE:
Send a plain text email to [email protected]
In the message SUBJECT, put just one word: UNSUBSCRIBE
================================================
TO SEARCH ARCHIVES:
Send a plain text email to [email protected]
In the message SUBJECT, put just one word: SEARCH-n
(where n is the number of days). In the message body,
place any
text to search for.
================================================
