Dawn
I had tried the ampersand and couldn't get the value 09242009-09302009.xls ? From: [email protected] [mailto:[email protected]] On Behalf Of [email protected] Sent: Saturday, October 03, 2009 8:34 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: DYNAMIC FILENAME FOR XLSPREADSHEET SET VAR VFNM TEXT = ((CTXT(.VSTDT)+'-'+(CTXT(.VTHRDT)+'.XLS'))) PRINT EMPPYSM2V2s1a WHERE enddate >= .VSTDT and enddate <= .VTHRDT + OPTION XLS + |FILENAME &vfnm + |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 Dawn Hast [email protected] wrote on 10/03/2009 09:26:01 AM: > 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 DISCLAIMER: This electronic message together with any attachments is confidential. If you are not the intended recipient, do not copy, disclose or use the contents in any way. Please also advise us by return e-mail that you have received the message and then please destroy. Evergreen Packaging is not responsible for any changes made to this message and / or any attachments after sending by Evergreen Packaging. We use virus scanning software but exclude all liability for viruses or anything similar in this email or any attachment.
