Fix Runtime Error 76, Path not found VBA error in Excel that occurs when Excel tries to access a file and cannot find it, by implementing the following suggestions.

Logically, you'll likely want your Excel VBA SaveAs button to actually save the file using the file path that the user provided rather than just discarding that name.