Copy a file from one folder to another and replace the existing file

I'm not sure if this is possible, but I want to get a file in one folder and copy it over to another folder, but if there is a file there with the same name I want to be able to replace that file. I have a code that will take the file and copy it over if the file doesn't exist already, but if it does it doesn't replace it. I tried Application.DisplayAlerts = False, but there are no pop up when I try the code.

Please Login or Register  to view this content.

Also does this only work for excel or could this also work for access files?

Could you use the Kill function to delete the existing file?