>
>when I run it again it does the same thing with the second file until all the files have been moved and processed
>
>Is that clearer - thanks for all your help
Yes, this code process all files in that folder.
If you do not need all just remove cycle :-)
lcFileName = SYS(2000,"c:\citisprint\sttach\*.*")
RENAME ("c:\citisprint\attach\"+lcFileName) TO ("c:\citisprint\attachxls\"+lcFileName)
But I'm still not sure what you mean by FIRST?
When I order files by name then first file is different than that when I ordered them by extension or by size.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.