Perhaps the file name captured by the input box doesn't exist. You're at the mercy of idiosyncratic mis-spellings by the user.

It's better to use the 

Workbooks.Open Filename:=Application.GetOpenFilename, etc.....
which throws up the standard Windows file open dialog box for the user to navigate through.

Rgds