File Not Found in correct directory, but able to read file name

Hello,

I have a peculiar error happening. I have a userform that opens a particular directory to read in all file names, then puts them into a list. After this happens it allows the user to delete them, but for some reason I get a "file not found" error on the following code --

Please Login or Register  to view this content.

The directory never changes or anything, and the program can read the file names in perfectly fine, but for some reason, when I try to open the file for input it errors out on me...

Please Login or Register  to view this content.

I don't understand what I'm doing wrong, unless I'm missing something blatantly obvious. The msgbox DOES return an existing filename in that folder, but it then cannot open it for input...

I'm stumped, and would greatly appreciate help

Thanks in advance,
GoogleBot

Do either of these work?

Please Login or Register  to view this content.

Hi

Your code works fine for me in test. What is the filename that is being returned Dir? Please post it exactly as it appears in your message box.

Richard

...

after the weekend, with no code changes, it suddenly is working?

...

RichardSchollar, the name was the exact file name -- "adsdf.txt" in this case, and that was what the msgbox showed...


How could I get excel to duplicate this error? I don't know what I would have changed over the weekend :-\ Is there any way network connections (being on a wireless vs ethernet cable) would cause something like this? It seems that because it accesses the C: drive that shouldn't matter

Only thing I can think of is this:

Note:

The ChDir lets you change the current directory on the current drive. If you need to change drives, try using the ChDrive statement first.

Perhaps somehow the 'active' drive letter isn't always right? But then it's still a mystery to me as to how the msgbox works.

Thought: I wonder if Excel does an 'autosave' operation if that would change the active drive, or folder?

To be honest to make sure I have everything right I've never used ChDir and assumed I'm in the correct directory / drive. I'd tend to do this:

Please Login or Register  to view this content.

Phil,

I believe that is exactly what I was trying to do. I was opening files from other drives, and that must change Excel's active drive.

I also think that the reason it was able to open the files and read the names in was because it specifies that folder and drive, whereas with my "Input" statement, it did not (I assumed it would keep that same drive/directory).

After experimenting with that for a while I have decided that including the entire path name is DEFINITELY the way to go when opening files where multiple drives might be in use

Thank you very much, I would have fought this for years before realizing it XD

Of course! You are correct about the msgbox. Looking back at the code that makes sense. Seems that little piece of 'debugging assistance' was actually a red-herring as it wasn't doing the 'EXACT' same thing as your actual code.
Still, glad we sorted it out, and yes, I truly believe fully qualified paths are the solution to many problems