SET DEFAULT TO ([w:\Quality Test 01\Source Data\]getfile.xls) COPY FILE (thisform.text9.Value ) TO [w:\Quality Test 01\mtest\]+(JUSTFNAME(thisform.text9.Value )+ [.xls])i try via this code i get just 1kb mean empty excel sheet.
lcFile22=JUSTFNAME(thisform.text9.Value) ? lcFile22 if adir(dummy,lcFile22)>0 MESSAGEBOX(" file exists") else COPY TO [w:\Quality Test 01\mtest\]+(JUSTFNAME(thisform.text9.Value )) ENDIFthanks