Copy files and delete current folder and subfolders

Hi,

I have the below macro that takes a copy of folders (and sub-folders) and places them in another file location.

I then need to delete the folders that I copied. I was getting an error because the file or folder was in use.

After that, I tried to create another instance of Excel and run the macro from there, however the folders do not get deleted. I suspect it is because I close the instance of Excel then I lose my reference to the file path?

First macro:

Please Login or Register  to view this content.

Second macro in another workbook and instance of Excel (the part highlighted in red does not seem to execute):

Please Login or Register  to view this content.

ok I will give it a try, thank you!

Just to confirm, how do I use MoveFile?

Should it be here:

Please Login or Register  to view this content.

with this:

Please Login or Register  to view this content.

I get a "permission denied" error.

Also,

Please Login or Register  to view this content.

makes no difference?