FindFile

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

CodeFunctionName
What is this?

Public

Tested

Original 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 6,142

Downloads 1,588

CodeID
DB ID

ANmarAmdeen
602
Attachments
Revisions

v1.0

Wednesday
July
11
2018