Next, check the VBA code to ensure that the file or folder path you specify is correct. Verify the path thoroughly, as a single mistake in the path can trigger the path not found with Runtime ...

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.