Never use macro (&) to reference a filename, use a name expression instead! It's faster and safer.
rename (gcTableName) To c:\temp.xdbf
>i am trying to rename any file that is selected by operator and call it FILE.dbf - from there it is processed.
>PROBLEM: when there is a space in the file name "This file.xls" i get error message 'command is missing required clause'
>see below code
>is there a simple code to remove spaces in filenames?
>
>thanks for help
>k
>
>gcTableName = GETFILE('dbf', 'Open Table:')
>rename &gcTableName To c:\temp.xdbf &&& here is where i get error message
>erase *.dbf
>rename c:\temp.xdbf To c:\File.dbf