Move files from one directory to another based on excel data

**CWinkler** · 04-28-2011, 05:01 PM

I need help coding this.

I've got a sheet with document file names (column G), the current directory (column H) and the future directory (column I). The future directories have already been created in a previous operation. The spreadsheet is located in the same place as the other folders.

It's something similar to this: http://www.excelforum.com/excel-gene...xcel-data.html

Can anyone help with this please? My VBA knowledge is just beginning.

Thanks!

Chris

**Leith Ross** · 04-28-2011, 05:17 PM

Hello Chris,

Welcome to the Forum!

The macro below will start in cell "G1" and go down to the last entry (file name) in that column. You can change "G1" to another cell if you want.

Please Login or Register  to view this content.

**CWinkler** · 04-28-2011, 05:17 PM

Thanks for the quick response.

I executed it, but I'm getting a Run-time Error '53': File Not found:

Please Login or Register  to view this content.

I figure I should mention that the destination folder has a space, it's usually something along the lines of "CN 12345"

**CWinkler** · 04-28-2011, 05:39 PM

I think you might have mispelled Range in there

Please Login or Register  to view this content.

I fixed the error when I ran it. Still does not work.

Please Login or Register  to view this content.

**Leith Ross** · 04-28-2011, 06:02 PM

Hello CWinkler,

Nice catch on my typo. Sorry about that. Glad you got it to work.

**CWinkler** · 04-28-2011, 06:36 PM

Unfortunately, I did not get it to work. Sorry, my posts were a bit cryptic. Office is crazy today.

The runtime error is still present.

**Leith Ross** · 04-28-2011, 08:13 PM

Hello CWinkler,

I think the back slashes are missing between the file path and file name.

Please Login or Register  to view this content.

**CWinkler** · 04-28-2011, 09:30 PM

No dice. Still same runtime bug.

**Leith Ross** · 04-28-2011, 09:43 PM

Hello CWinkler,

This statement should work in Excel 2007. Are you providing the full path for the current directory? What error are you getting now?

**CWinkler** · 04-28-2011, 10:05 PM

Double-checked this against new files and folders. It worked! The excel column for Filepath and NewPath must contain the entire path of the files, not just the folder name in the same directory as the excel.

ie:
D:/Folder/Filepath
instead of just
Filepath

Is there a way to make it copy files to the destination rather than just relocate them?

Thanks!