How to copy a file to a folder if there is already a file with the same name?

Question

I am trying to write an Excel VBA macro that will loop through a list of folder paths, fetch all the files inside these folders and copy them to a single folder. Everything works fine until the macro reaches to a file that already exists in the destination folder, and then it returns the message: "run time error 70 - permission denied"

here's the code I'm currently using:

FSO.CopyFolder Source:=FromPath, Destination:=topath

If possible, I would prefer to overwrite the duplicate files.

Thanks in advance!

why not try deleting the file first if it already exists? [see here for more info](http://stackoverflow.com/questions/67835/deleting-a-file-in-vba) — Noam Hacker, Mar 01 '16 at 21:21

Porcupine911 · Accepted Answer · 2016-03-01T21:48:53.337

2

The CopyFolder method has an optional OverWriteFiles argument...

FSO.CopyFolder Source:=FromPath, Destination:=topath, OverWriteFiles:=True

edited Mar 01 '16 at 21:48

answered Mar 01 '16 at 21:22

Porcupine911

928
9
22

it gives me this message: "runtime error 448 - named argument not found" – Lev Mar 01 '16 at 21:37
Corrected argument name to OverWriteFiles. Try that. – Porcupine911 Mar 01 '16 at 21:49
The problem is not that the file exists then. Still researching. – Porcupine911 Mar 01 '16 at 21:56
really does sound like a permissions issue – Porcupine911 Mar 01 '16 at 21:58
yes, you were right, I changed folder permissions - now it works like a charm! Do you know if there's a vba code to change folder's permissions? – Lev Mar 01 '16 at 22:22

How to copy a file to a folder if there is already a file with the same name?

1 Answers1