Hi,

I'm not sure why the following vba code does not work as intended if
the existing excel file is found and activate but it keeps prompting
the error message that the file is not found

Dim Wbk As Workbook
For Each Wbk In Workbooks
If Wbk.Name = "GL.xls" Then
Windows("GL.xls").Activate
Else
MsgBox " The required file is not found - process end"
Exit Sub
End If
Next Wbk

Please help, thanks in advance

Regards
Len