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.

To fix Interface not registered error 0x80040155 in Outlook, Excel, etc; register this DLL file or repair or reinstall Office. More suggestions here.