I have a Userform that is essentially two combo boxes that are populated by the open workbooks. Is there a way I can exclude PERSONAL.XLSB from this list? This what I have:
Sub UserForm_Initialize()
Dim wkb As Workbook
With Me.ComboBox1
For Each wkb In Application.Workbooks
.AddItem wkb.Name
Next wkb
End With
With Me.ComboBox2
For Each wkb In Application.Workbooks
.AddItem wkb.Name
Next wkb
End With
End Sub
try
If you don't want to rely on the file extension being visible, you can check the file format instead.