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
which throws up the standard Windows file open dialog box for the user to navigate through.
Workbooks.Open Filename:=Application.GetOpenFilename, etc.....
Rgds
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
Hi Richard,
Thank you for responding. I am using the method you mentioned which gets the open file window, but my point is why my previous code is not working, yes the file exist and I am typing the correct name.
thanks
Jaz
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks