Sub OffeneDateien() Dim wkbMappe As Workbook Dim lngZeile As Long lngZeile = 10 For Each wkbMappe In Workbooks Cells(lngZeile, 2) = wkbMappe.Name lngZeile = lngZeile + 1 Next wkbMappe End Sub
For Each wkbMappe In Workbooks If wkbMappe.Name <> ActiveWorkbook.Name Then Cells(lngZeile, 2) = Application.Substitute(wkbMappe.Name, ".xls", "") lngZeile = lngZeile + 1 End If Next wkbMappe
58.4k Fragen
249k Antworten
7k Nutzer