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.