FindFile

Finds if a workbook is open or not in same Excel session


Public

Tested

My Own Work
Function FindFile(FileName) As Boolean
 Dim Fo As Boolean
 FindFile = False
 For i = Workbooks.Count To 1 Step -1
  If UCase(Workbooks(i).Name) = UCase(FileName) Then
   FindFile = True
   Exit Function
  End If
 Next i
End Function

FileName

Views 4475 Downloads 1133

VBA-Excel Sessions
ANmarAmdeen
655
Attachments
Revisions

v1.0