To check if a workbook is open using a VBA code, you need to use FOR EACH loop that can loop in all the workbooks that are open at the moment and verify each workbook’s name with the name you have mentioned. You can use a message box to get the result of the loop.
Check IF a WORKBOOK is OPEN
- First, you need to declare variables to use in the code to create a loop.
- Use an input box to get the name of the workbook that you wish to search for.
- Start the loop to loop through all the open workbooks.
- Write code with IF STATEMENT to verify the name of the workbook with the name you have entered in the input box, and once the name matches, activates the workbook, show a message box that workbook is found, and exit the procedure.
- In the end, end the loop and use a message box to show a message box if nothing has been found.
Here’s the full code.
Sub vba_check_workbook() Dim WB As Workbook Dim myWB As String myWB = InputBox(Prompt:="Enter the workbook name.") For Each WB In Workbooks If WB.Name = myWB Then WB.Activate MsgBox "Workbook Found!" Exit Sub End If Next WB MsgBox "Not Found" End Sub
More Tutorials on Working with Workbooks in VBA
- How to Create a New Workbook using VBA
- How to Save or Save As an Excel File using VBA
- How to Close an Excel File using VBA Code
- How to Delete a Workbook using VBA
- How to use to ThisWorkbook in VBA
- How to Change Name of an Excel File using VBA
- How to Activate an Excel File using VBA
- How to Combine Excel Files using VBA
- How to Protect\Unprotect an Excel File using VBA in Excel
- How to Open an Excel File using VBA
- How to Check IF an Excel File Exists in a Folder