copying files from one location into another.

[CWinkler]

Hello again,

Leith answered my question here, but I realized I asked the wrong question.

http://www.excelforum.com/excel-prog...xcel-data.html

This works, but is there a way to make it copy files from the original path to the destination rather than just relocate them?

Thanks Again!

[CWinkler]

We're starting with this code as it identifies the correct cells and the correct locations:

Please Login or Register  to view this content.

[snb]

this suffices:

Please Login or Register  to view this content.

[CWinkler]

Thanks SNB! I'll have to try that as well. Looks like some compact code there.

I found another solution, replaced the Name fucntion with the FileCopy function. Seems to work perfectly, and I understand it

Please Login or Register  to view this content.

[CWinkler]

Having new issues with an error code "run-time error '53': File not found". It's calling out the line with the FileCopy function on the debug.


Ran a check on a sample of data and all files and folders are there, the functions are calling out valid locations I also added code to check for the destination folder and create it if it isn't there.

Please Login or Register  to view this content.

[snb]

Use VBA's builtin facilities

Please Login or Register  to view this content.

[CWinkler]

I've since tweaked this code, but can't get it to work again. Keep in mind this file and the data being sorted is on a local network on not on my machine. All file locations are entered as text strings and not formulas of some sort.

I get a "path does not exist" error on the FSOobj.CreateFolder NewPath, but it's supposed to be creating a path based on the text string in column I.

Please Login or Register  to view this content.

[JBeaucaire]

Here's a macro for creating all the folders and subfolders in a string path. There's a macro and a UDF version that other macros can use.

Make Folders and Subfolders

I added the UDF version of this code below your original macro, then called it to make your folders for you as needed.

Please Login or Register  to view this content.

[CWinkler]

Thanks, the MakeFolders function did exactly what I wanted it to.