Runtime error 53 on filecopy

[mwilkes]

I am running a macro to copy a list of 120k files in column A to a new folder path in column B. I tested it before running and it skipped temp files and files that did not exist in the source directory. Here is the code:

Please Login or Register  to view this content.

I set it to run last night and this morning found a "Runtime error '53' file not found" on FileCopy c.Value, c.Offset(0, 1).Value at line 5.8k. I need this up and running ASAP. Can anyone tell me why this happened?

edit: the file it stopped on does exist, not that it should matter.

[judgeh59]

is it possible that, that particular file has different permissions and you aren't allowed to do a copy....just shooting in the dark

[mwilkes]

I am owner of the directory.

[judgeh59]

understood, but are file permissions different

[mwilkes]

Checked permissions on every file in the subfolder, not just the one in question. Full control on all users. There was a permissions issue with one folder but I manually set them one by one and they are not even in this batch of files to be copied. It must be something else.

[judgeh59]

that was my only idea....sorry....

[mwilkes]

That's ok. I can usually figure these out by myself but I'm stumped. File exists, permissions are good, the code skips files that don't exist so even if the path was bad it should have kept running. I don't get it.

[mwilkes]

Is there any addition I can make to the code to skip to next line if this error pops up?

[mwilkes]

Will on error resume next work?