Use Excel to copy files to a location in disc

**sp_key** · 08-20-2009, 11:26 AM

Hi all,

This is my first post here.
I have a worksheet with three columns.
Column A is the list of files (filenames) I want to copy.
Column B is the location of those files in my hard drive.
Column C is the location I want to copy those files to.

Is there any way of doing this?

PS: Please be simple - I rarely use Excel.

Thanks in advance!!
Sp

**mrice** · 08-20-2009, 03:29 PM

Try this macro

Please Login or Register  to view this content.

**sp_key** · 08-21-2009, 04:41 AM

mrice, thanks for your quick response.

I get the following error: Run-time error '70': Permission Denied.

Any thoughts?

**mrice** · 08-21-2009, 12:07 PM

It would be worth trying to do one of the copies manually just to check that you aren't lacking permission to copy to the destination folder.

I've assumed that you columns look something like

MyFile.xls c:\Folder1\SubFolder1 c:\Folder2\SubFolder2