Moving Files from Folder and Subfolders

**mvinay** · 01-29-2014, 07:15 AM

Hello All,

I need to move all the "Excel" files which are available in Folder and also the Subfolders from this location.

I need all the Excel files.

I found a code which is able to move only from Folder but not from the Subfolder.

Kindly help me.

HTML Code:

**codeslizer** · 01-29-2014, 10:33 AM

Hello mvinay,

Give it a try to the attached file. I've used the following code to make it work. Here, vFrom and vTo are the range names that I've given them. The code would not only move Excel based files but also the csv files that are also frequently used in excel. Could remove it from the array if you don't want. That means, if you want you can also add the extensions which you'd like to move along with Excel files.

Let me know for if things don't work out for you.

Please Login or Register  to view this content.

**mvinay** · 01-30-2014, 12:10 AM

Hello Codeslizer,

This code is able to move the Files only from Selected folder. But I have Other subfolders in the Selected folder and I need have the all the Files need to moved from Selected folder and also from the Sub-Folders.

Kindly check the attached image, which shows the files and subfolder. I also have files in these subfolders and all these need to be moved in single click.

Please provide the code.

Thanks in Advance.

**codeslizer** · 01-30-2014, 01:59 AM

Hello mvinay,

Below is the link to the code to iterate through each sub-folders in a given path.

http://www.excelguru.ca/forums/showthread.p....-that-contains-folder-name-as-Numeric

Use the main code for moving within the code in the link.

Moving Files from Folder and Subfolders

LinkBack

Thread Tools

Rate This Thread

Display