Alright. So your question is why are some of your macros giving you the error "Can't find Folder Path". And you say this last one doesn't give that error.
What you did (to help us) was show us some "working macros" that are very similar to your non-working macros. Looking at your working macro may not tell us why your non-working macros aren't working.
One time I told my doctor that my left ear wasn't working properly and he immediately looked at my right ear. I said "Doctor, that's the wrong ear." He said, "I know, I just want to establish a baseline first."
So sometimes having a baseline can be useful. I'm not sure it's useful in this case. In this case my approach would be to look at the failing macro. It seems that you posted a very trimmed down version of the failing macro at the top of this thread, and a less trimmed down version of a working macro near the end of the thread. (But there doesn't seem to be a less trimmed down version of the failing macro anywhere - the one that gives you the "can't find Folder Path" error.)
We totally accept the fact that you must remove personal information from your macro especially financial information, and perhaps people's real names. But it can be problematic if you don't tell us which actions you edited out personal information from. My guess is that you edited out information from your directory path. But if I guess the wrong thing it may be impossible to find the solution.
Since your original post was asking about a "Can't find Folder Path" error, would it be possible for you to post a minimally trimmed down version of that macro? Ie, the one that we're trying to fix?
If this is frustrating, I apologize. If you do edit out any actions to remove personal information, that's fine, but can you tell us which actions you edited? Because there's a very real possibility that the stuff you edited out is the very stuff that's causing the "Path Not Found" error.