If there is a space in the path or file name, macro substitution will fail.

Try APPEND FROM (cPsFilePath) SDF

>I am using the following code and it works fine
>
>

>SELECT New_Bills
>SCAN  && Scans for New_bills up to EOF()
>*Define Variables
>	cPsfilepath=ALLTRIM(Myfilepath)
>	CREATE CURSOR Billcompress (POS C(254)) && Create Temporary Cursor
>	SELECT Billcompress
>	APPEND FROM '&cPsFilepath' SDF
>

>
>However when I use APPEND FROM cPsFilepath SDF, it generates error as file not found.
>
>My Questions.
>(1) IS it necessary to have Macro substitue. ?
>(2) Where and Why Macro Substutes are used ?
>(3) Does use of Macro substitue decreese the processing speed ?
>
>Kinldy Guide