Could your users be choosing a directory with spaces? In that case you need to put quotes around the path/file name. Try this:
COPY TO "&lcExportFile" TYPE XLS
>In VFP 5.0 I am encountering a problem. I have a cursor called csrGrid built from a SQL. I use this cursor to populate a grid. When the grid is displayed, I have a command button that will export the data from the cursor to an Excel spreadsheet. When you click on the button, I display a common dialog box and let the user select drive, dir and file name of the spreadsheet Here is the problem:
>
>COPY TO &lcExportFile TYPE XLS
>
>Let's say lcExportFile equals 'c:\temp\export.xls'. This works perfectly in VFP, but when I create the .EXE and distribute, the users are recieving error message #
1, File 'PARENT' does not exist. I changed the COPY TO statement to COPY TO 'c:\temp.export.xls' TYPE XLS and it worked fine in the .EXE.
>
>Any ideas why the macro substitution would generate this error? Thanks in advance for any suggestions or alternatives.
>
>Kind Regards,
>
>Mat Kennedy
>Decision Support Technology Inc.