Copy excel and text files from one folder to another folder...

Hi Friends,

Very Good Morning........


I am daily copying the excel and text files from one folder to another folder and preparing report. Like that I have 10-15 folder are there.

Could you please any one help on this.


Thanks & Regards,
Pradeep

Dear annupojupradeep,

Hope this link will help you...

http://www.excelforum.com/excel-prog...ml#post3455697

Regards,
Harish S

Hi Harish,

Thank you so much.....

Its working for file with same name. I have criteria that is


Example:


Original folder name is US-GP1

files are A1.xls, A1.txt , B1.xls and B1.txt

I need to copy the all the above file and paste in folder US-QP1


Again Another original folder name is EU-GP1

files are A1.xls, A1.txt , B1.xls and B1.txt (With same file name)

I need to copy the all the above file and paste in folder EU-QP1

Like that I have 10-15 original folder GP1 and respecting another folder name QP1. File names are same for all folders.
So I need to copy the file from GP1 to QP1.


Could you please help in this.

Thanks & Regards,
Pradeep

Dear Pradeep,
As per my knowledge, there is no extension for a Folder like *.xls, *.txt etc.

From the code/link, i shared earlier... you will have to write the code for all the files of the folder... this will be an 01 time activity for you to write the code.

If any of the experts can reply with solution, I will learn from them too...

Regards,
Harish S