Thre's no reason to use macro substiotution where Name Expressio0n will do
COPY TO (loc) TYPE XL5
COPY TO (loc)
>Just discovered a problem in some 5 year old code. I run a query and store to a cursor. I then launch some code to export the results to either a .dbf or .xls file after choosing the save location, filename, and type. I end up with a variable such as:
>
>loc = "C:\BRUCE COVEY\export.xls" or "C:\BRUCE COVEY\export.dbf"
>
>I then issue:
>
>COPY TO &loc TYPE XL5 or COPY TO &loc depending on selection.
>
>PROBLEM:
>Command always fails with nerror 36 if there is a SPACE in any of the folder names. If I change the folder above to "BruceCovey" it works fine.
>
>Does anyone have insight on this?
>Would be much appreciated.
--sb--