Problem with code - move files to another directory

Hi

I have the following macro to move files from one folder to another,however I get an error if the file already exists. I have read many other snippets of code to resolve this, however I am still having problems

Here is the code I currently have

Please Login or Register  to view this content.

Any help would be great
Thanks

hi there,

thanks for the reply however i am not what the above code does. i only want to move all files from one folder to another, not the entire folder. the folder always needs to remain in the original location (only the individual excel files should be moved)

Thanks again

Hi,

I need the files to be moved as another macro picks up files from the original location. If they are not moved then they would be picked up again, which I do not want. That is why I want to move them to another location rather than copy.

I want to move all files from:

F:\OLDFOLDER

to

F:\NEWFOLDER

The code I provided above does work in the first instance, however it does NOT work if the file already exists in the new folder location. If this is the case then I would like to overwrite the file however I cannot figure out how to do this.

I am not sure how to work that into the code you provided.

Thanks again