Tip: In the above VBA, “ combine” is the workbook name you want to check, you can it as you need. And press F5 key to run this vba, and a dialog pops out to remind you the specific workbook is open or not. MsgBox "The file is not open", vbInformation, "Kutools for Excel"ģ. MsgBox "The file is open", vbInformation, "Kutools for Excel" VBA: Check if a workbook open or closed Function IsWorkBookOpen(Name As String) As Boolean Click Insert > Module and then copy and paste the VBA to the new Module window. Press Alt + F11 keys to open Microsoft Visual Basic for Applications window.Ģ. Here is a VBA code you can run to check if a specific workbook is open or closed.ġ. Give up the traditional method on checking files one by one, here I introduce you the tricks to quickly find a workbook is open or closed.Ĭheck if a workbook is open or closed with VBAĬheck if a workbook is open or closed with Kutools for Excel How to quickly check if a file (workbook) is open or closed in Excel?Įxcel daily work, you open multiple workbooks at the same time for working, but sometimes, the hundreds of workbooks may mess your head to remember if a specific workbook is open or closed.
0 kommentar(er)
