Reborg,
I am sorry that I copied wrongly. The code is working now but IF i have 2 files namely CARE01_DLY_AUS_20060721 and CARE01_DLY_MKT_20060721
It's creating only 1 new file named CARE01_DLY_MKT_20060721 _new. But what happened to the other file namely CARE01_DLY_AUS_20060721 _new. It's writing only 1 file.
Once again I am sorry to copy it worngly. It happened because i copied wrongly.