>>
>>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.
I have say 10 files in the directory called attach
on day one for example when I run my code i want to move one of these files to the attachxls directorey with a filename of attach.xslx
I then convert this file to an xls file and process it - the are now only 9 files in the original attach directory
On day 2 for example I want to do the same thing - with the first of the remaining 9 files
Specialist in Advertising, Marketing, especially Direct Marketing
I run courses in Business Management and Marketing