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
you can use this command
also you can save it as a batch file to run in scheduled time
SET MoveDirSource=c:\sourceSET MoveDirDestination=d:\destinationROBOCOPY "%MoveDirSource%" "%MoveDirDestination%" /MOVE /E
also you can save it as a batch file to run in scheduled time
Open in new window