FindFile

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

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 546 Downloads 153

'Excel', 'workbook', 'workbooks', 'open', 'session', 'find', 'file', 'search'

ANmarAmdeen
324
Attachments
Sessions VBA-Excel
Revisions

v1.0