Copying to a dynamically named Excel File 1

[MMund]

I am building a cursor with a SQL query and then exporting its contents to an Excel file with a name that will consist primarily of the system date, to wit:
'E'+RIGHT(DTOS(DATE()),6)

I also need to copy this file to a specific directory, but when I attempted to use this command:

COPY TO ../../monitor/'E'+RIGHT(DTOS(DATE()),6) TYPE XLS

I get the Unrecognized Command error. Any ideas as to how I could accomplish this?

Thanks in advance

 

[JanBucek]

store "../../monitor/E"+RIGHT(DTOS(DATE()),6) to lcFileName
copy to (lcFileName) type xls

 

[MMund]

Thanks, that did the trick!

 

[ezopaci]

or
COPY TO ('../../monitor/E'+RIGHT(DTOS(DATE()),6)) TYPE XLS

Tomas