How to move all files from subfolders to one folder by VBA code ?

Experts,

I have one Folders and it has some sub folders and Subfolder has files like excel , word etc... I would like to have one small program when i set source and destination folder and run the script to get all only excel files to Destination folder.

Please let me know if you need more clarification..

Thanks,

Microsoft ExcelVisual Basic ClassicVBA

Last Comment

sharepoint0520

8/22/2022 - Mon

Temody

10/7/2015

you can use this command
also you can save it as a batch file to run in scheduled time

SET MoveDirSource=c:\source
SET MoveDirDestination=d:\destination
ROBOCOPY "%MoveDirSource%" "%MoveDirDestination%" /MOVE /E

Open in new window

ASKER CERTIFIED SOLUTION

NVIT

10/7/2015

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.

View this solution by signing up for a free trial.

Members can start a 7-Day free trial and enjoy unlimited access to the platform.

See Pricing Options

Start Free Trial

GET A PERSONALIZED SOLUTION

Ask your own question & get feedback from real experts

Find out why thousands trust the EE community with their toughest problems.

Temody

10/7/2015

sorry i don't see (only excel files)
please try this

SET MoveDirSource=c:\source
SET MoveDirDestination=d:\destnation
ROBOCOPY *.xls* "%MoveDirSource%" "%MoveDirDestination%" /MOVE /E

Open in new window

sharepoint0520

10/7/2015

ASKER

Hi,

Can you please write codes in Module or any Excel form ? Is it possible to attach Excel file for you guys ? I am not clear to use Function.

Experts Exchange has (a) saved my job multiple times, (b) saved me hours, days, and even weeks of work, and often (c) makes me look like a superhero! This place is MAGIC!

Walt Forbes

sharepoint0520

10/8/2015

ASKER

NVIT,

How to use this function in Module ? I would like to Button to click to move files. Any advice?

sharepoint0520

10/19/2015

ASKER

I got it.

Certified Expert Program

Credly Partnership

Udemy Partnership