copying all .xls file to single parent directory

[Venus_excel]

Hi all,

Hope u ppl can help.

i need to copy all .xls file into single folder and this folder contains multiple subfolder, and further subfolders in each of them, and so on..

so all excel files should be in a single folder.

THanks in advance

 

[Venus_excel]

Hi VBA Geek,

Its working fine. Really you helped at this critical situation and thanks for your support.

 

[Venus_excel]

Hi VBA Geek,

Im getting this error msg "some files were not copied".
Can you pls guide me why Im getting this error.
Thanks

 

[jsotola]

why are you using VBA to do the task?

why don't you use windows explorer ? (i am assuming that you are using ms windows)

 

[Venus_excel]

Hi Jsotola,

My requirement is "copying all excel files to single folder" in VBA.
Code i used is not copying all the files.

 

[VBA Geek]

Are you copying a new set of files?

 

[jsotola]

My requirement is "copying all excel files to single folder" in VBA.

is this a homework assignment from school ?

 

[Venus_excel]

Hi VBA Geek,

1) All files are in .xlsx format
2) Folder contain 40 files and code copied only 29 files and pop-up raised says "some files were not copied".

 

[jsotola]

have a look here

How To Search Directories to Find or List Files

 

[VBA Geek]

did you input xlsx in the format input box?

are they located in one folder or in subfolders as well?

 

[Venus_excel]

ya ..you are right VBA Geek

Files are located in subfolders as well