You can fix VBA Runtime Error 1004 in Excel Macro, like document not found, reference isn't valid, Paste method of worksheet class failed, etc, by following this post.

In light of these issues, we’ve been seeking out the most reliable methods to fix them. The latest reported issue is causing players to get stuck under the map.