...
|FILENAME .VFNM +
...
Should do it for you. (That's the variable name preceded by a full stop.)
Regards,
Alastair.
----- Original Message -----
From: mike epstein sony viao office
To: RBASE-L Mailing List
Sent: Saturday, October 03, 2009 2:26 PM
Subject: [RBASE-L] - DYNAMIC FILENAME FOR XLSPREADSHEET
Good Morning all
Having a blurb and maybe some on can help.
SET VAR VFNM TEXT = ((CTXT(.VSTDT)+'-'+(CTXT(.VTHRDT)+'.XLS'))) I would
like a variable to be the filename using two dates
PRINT EMPPYSM2V2s1a WHERE enddate >= .VSTDT and enddate <= .VTHRDT +
OPTION XLS +
|FILENAME NEW.XLS + How would I express the variable here?
|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
Thanks
Mike
------------------------------------------------------------------------------
No virus found in this incoming message.
Checked by AVG - www.avg.com
Version: 8.5.409 / Virus Database: 270.14.3/2411 - Release Date: 10/03/09
06:20:00
