AW: in VBA: Workbooks.Count
17.03.2021 16:08:59
Rudi
Hallo,
das kannst du nur mit einer eigenen Klasse der Application erreichen.
In deiner Hauptanwendung:
In DieseArbeitsmappe:
Private Sub Workbook_Open()
Set objApp = New clsApplication
End Sub
In einem Modul:
Public objApp As clsApplication
Füfe ein Klassenmodul 'clsApplication' ein.
Code:
Dim WithEvents myApp As Application
Private Sub Class_Initialize()
Set myApp = Application
End Sub
Private Sub myApp_WorkbookOpen(ByVal Wb As Workbook)
ThisWorkbook.Sheets(1).Cells(1, 1) = Workbooks.Count 'Blatt/ Zelle anpassen
End Sub
Private Sub myApp_WorkbookBeforeClose(ByVal Wb As Workbook, Cancel As Boolean)
ThisWorkbook.Sheets(1).Cells(1, 1) = Workbooks.Count - 1 'Blatt/ Zelle anpassen
End Sub
Gruß
Rudi