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.