Just make sure the variable 'lcExcelFileName' contains the proper file name...
lcExcelFileName = addbs(ab4) + juststem(mTableName) + ".xls"
copy to ( lcExcelFileName ) Type XL5
>
>The codes copy all dbf files to present directory.
>But I want to copy all dbf files with their orinal names to following location
>ab4
>How to modify path in this line
>
>copy to type xl5
>
>Please help
Steve Gibson