Automate moving files around

**glide2131** · 06-20-2014, 02:10 PM

So I was wondering if there was a good way to automate the task of moving files around.

I have a lot of scanned documents that I have saved in one folder on my computer. I went through and renamed them
the same name that the folder which they need to go into has. I was wondering what the best way (if any) to
automatically move all these files to the correct folders on my computer.
I don't want to create new folders or write over existing folders. I just want the files to be moved around to the
correct folder.
Does anyone know how this can be done?

**mrice** · 06-20-2014, 03:14 PM

Suggest using a macro like

Please Login or Register  to view this content.

where current path is in column A and new path in column B.

An easy way of getting the current paths is to go to windows explorer, select all the files in the folder, hold down the shift key, right click on any of the files, select copy as path and then paste into column A.

To add the code....

Open up the VBA editor by hitting ALT F11

Insert a new module by hitting Insert - Module

Paste the macro into the empty sheet

Hit ALT F11 to get back to the worksheet.

Run the macro by going to tools-macro in Excel 2003 or the view ribbon in Excel 2007/2010.