Move Doc files from multiple folders in same drive into one folder.

[Jagdev Singh]

Hi Experts,
Please let me know if this is possible with excel VBA which will move doc files from same drive and same main folder. The main folder contains 4 sub-folders with doc files in it. I need these entire doc files in a single folder is this possible?
Regards,
JD

 

[wudixin96]

Can use VBA\vbs\bat and so on

it's bat file below,copy and paste into notepad,save as a bat file
replace the path of mainfolder and destfolder as your path

@echo off
set mainfolder=d:\aaaa
set destfolder=e:\bb

for /f "delims=" %%i in ('dir /b/s "%mainfolder%\*.doc*"') do (
  call move "%%i" "%%destfolder%%\%%~nxi"
)
echo Completed !!&&pause>nul

 

[Hui]

or if it's a one-off

Goto Windows Explorer
Find the Main Folder
In the Search Box (Top Right Corner) search for *.doc*
When it has finished searching
Select Any File
Ctrl A
Right Click on any file - Cut or Ctrl+X

Move to the new Folder
Right Click in the folder and select Paste or Ctrl+V

 

[Jagdev Singh]

Hi Hui and Wudixin

Thanks for your help

Regards,
JD

 

[Jagdev Singh]

Hi Both

The below code does the same task via excel

Sub blah()
PathArray = Array("E:\test1\Subfolder1\", "E:\test1\Subfolder2\", "E:\test1\Subfolder3\", "E:\test1\Subfolder4\")
For Each oldpath In PathArray
  newpath = "E:\test2\"
  Fname = Dir(oldpath & "*.doc*")
  Do While Fname <> ""
    Name oldpath & Fname As newpath & Fname
    Fname = Dir
  Loop
Next oldpath
End Sub

Regards,
JD

 

[Jagdev Singh]

Hi Wudixin

Can we have bat file to convert 100's of word doc to PDF?

Regards,
JD

 

[Hui]

JD

Have you searched on an Word Blogs ?
I am sure that has been answered more appropriately in them

 

[wudixin96]

Of course,need to download a software