FindFile

Finds if a workbook already open in Excel session giving workbook name (without path), returns true or false

Function FindFile(Filename)
 FindFile = False
 For I = 1 To Workbooks.Count
  If Workbooks(I).Name = Filename Then
   FindFile = True
   Exit Function
  End If
 Next
End Function

Filename

Views 431 Downloads 221

'workbook', 'open', 'workbooks', 'files', 'find', 'search'

ANmarAmdeen
326
Attachments
Components VBA-Excel
Revisions

v1.0