在第2次迭代期间，“运行时错误462:远程服务器机器不存在或不可用”

I am aware this is very close to other questions but I have failed to identify my problem through other posted solutions which is why I am posting it now. I have indicated in the code where the error pops up during the 2nd iteration. Here is an example of a I am aware this is very close to other question