Cutting & Moving A file

[jablo1312]

I'm currently using VBA to copy and paste a group of files from 1 folder to another. The folder contains logs everytime a certain report is accessed, so it is constantly updating with new files. I've already figured out how to merge all individual files in a folder into 1 single workbook sheet. But what I'm trying to do is have the VBA cut the files from their original location and then paste them in a new folder, so that everytime I move the files VBA doesn't attempt to move all files, including old ones.. Does anyone know what code I can use to do this?

Please Login or Register  to view this content.

[jablo1312]

I was able to solve this problem as well. Its pretty simple, all that needs to be done is to replace the word "copy" in the following script with"move"

Please Login or Register  to view this content.

This will take all files in the "FromPath" folder and move them to the "ToPath" folder, while also removing them from the "Frompath" folder.

[jablo1312]

I was able to solve this problem as well. Its pretty simple, all that needs to be done is to replace the word "copy" in the following script with"move"

Please Login or Register  to view this content.

So that it looks like this:

Please Login or Register  to view this content.

This will take all files in the "FromPath" folder and move them to the "ToPath" folder, while also removing them from the "Frompath" folder.