Invalid procedure call argument

Hello,

I am running this script:

Please Login or Register  to view this content.

After the first round in the loop, I am getting a Run Time Error '5' - Invalid procedure., however, if I remove the "IF" procedure, the script runs through.


What is wrong here? Could you please advise?
Thanks

You cannot use Dir inside the loop, otherwise you destroy the stack, from the first Dir.
To check if the file exists in a different folder use file system objects.
https://analystcave.com/vba-filesyst...ba-fileexists/