Bad File Name or Number in VBA

[kamisha05]

Hello, I have the following code and continue to receive the run-time error #52: bad file name or number

Open FName For Input Access Read As #iF1    
    While Not EOF(iF1)
        Line Input #iF1, WholeLine
        If Right(WholeLine, 1) <> Sep Then
            WholeLine = WholeLine & Sep
        End If
        
        
        RowNdx = 2 * StarCnt + 1

When I hover over the FName, it shows the correct file that I have input, but I am not sure why it is a bad file name. It only has letters and numbers, with no special characters. What other issues could be wrong with a file name?

 

[John_w]

Is iF1 assigned? You would normally use the FreeFile function to assign the next available file number.

 

[kamisha05]

Hi John, thanks for the reply. Yes, it is assigned. Here is the code right above the FName line:

    iF1 = FreeFile    RowNdx = 1
    ColNdx = 1
    StarCnt = 0
'


Open FName For Input Access Read As #iF1
    
    While Not EOF(iF1)
        Line Input #iF1, WholeLine
        If Right(WholeLine, 1) <> Sep Then
            WholeLine = WholeLine & Sep
        End If
        
        
        RowNdx = 2 * StarCnt + 1

 

[kamisha05]

Also, I notice when I hover over iF1 = FreeFile, it shows iF1 = 0. So, for some reason it is not showing a value for iF1