Method'OpenText' of object 'workbooks' failed

**jazbath** · 11-13-2009, 02:11 PM

Hi,
I am getting the subject messsage when I run the following code:

HTML Code:

the puzzling thing is that sometimes it works but most of the time it gives me that message. Any idea?
Thanks for the help.
Jaz

**Richard Buttrey** · 11-13-2009, 02:25 PM

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

**jazbath** · 11-13-2009, 02:41 PM

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