Logo 
Search:

MS Office Answers

 Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: Juana Fisher   on Aug 26 In MS Office Category.

How to know state of opened or Closed File in Excel


  
Question Answered By: Sherrie Thomas   on Aug 26

Microsoft's own solution:

Function IsOpen(FileName As String) As Boolean
Dim wb As Workbook
For Each wb In Application.Workbooks
If UCase(wb.Name) = UCase(FileName) Then
IsOpen = True
Exit Function
End If
Next wb
IsOpen = False
End Function

Share: 

 

This Question has 1 more answer(s). View Complete Question Thread

 
Didn't find what you were looking for? Find more on How to know state of opened or Closed File in Excel Or get search suggestion and latest updates.


Tagged: