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 4754 Downloads 1188

VBA-Excel Sessions
ANmarAmdeen
674
Attachments
Revisions

v1.0