Hi Andrew,

try
COPY TO ( THIS.cUserXLSFile) TYPE XL5

The brackets perform Name substitution.

Regards
Mark

>Hi,
>I wish to create a unique output file for each user hitting my web based application (DLL). The SYS(2015) call does this nicely, but I can't figure out the code to use with the COPY TO in order to refer to this file. I am sure that I am missing something fundamental here!
>
>After validating my user name and password I assign a unique file name.
>
>THIS.cUserXLSFile = "DIR" + SYS(2015) + ".XLS"
>
>I would like my query builder to to use the newly created file, for this user, overwriting any previous file with the same name. This function is called for all queries.
>
>COPY TO THIS.cUserXLSFile TYPE XL5
>
>If I include the COPY TO "DIR" + SYS(2015) + ".XLS" things work as planned, except that I do not want a unique file every time this part is called in my procedure.
>
>How can I get VFP to use my THIS.cUserXLSFile reference within my query buildr function ?
>
>Any assistance would be greatly appreciated.
>
>
>Andrew Logie
>
>Institute of Food Research
>logiea@bbsrc.ac.uk