HI OssieMac,

The file names may consist of "N" characters but the name of the file ending
with numberic will have 3 digits and initial name of the file are characters.

Hope I have answered your query so that you can able towrite code correctly
to help me.

Thanks

"OssieMac" wrote:

Hi Vijay,

Just like to confirm the format of the file names. Your post suggests (but
does not specifically say) that there are 3 alpha and 3 numerics in all of
the file names. Can you confirm this. If not correct, then do all of the
files have the same number of non numeric characters and the same number of
numeric digits? If so, is it 3 alpha and 3 numerics?

It makes a real difference as to how the code needs to be written.

--
Regards,

OssieMac


"Vijay Kotian" wrote:

Hi,

I seek your help for the following;

I have few files in one of the folder. The file names are ending with
numeric number. The uniqueness of the file names are they are serially
numbered e.g. ABC123.xls, XYZ124.xls, MNO_AB125.xls, LKM126.xls. I would
like to open these files serially (...123 then ...124 so on so forth till
last files in the folder).

Once the file is open i would like to do some processing and save it in
another folder. The files once opened and saved in another folder it should
get deleted from earlier folder (From where the file was opened).

Thank you.