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 --


    Open temp For Input As #1
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...
Sub test()

    Close
    Dim temp As String
    
    ChDir "C:\oracle_excel_templates"
    
    temp = Dir("C:\oracle_excel_templates\*txt")
        
        'Make sure a file was found
    MsgBox temp
     
    Open temp For Input As #1
    
    Close
    
End Sub
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