AW: Viell wdn mittendrin im Bereich jedesmal ...
01.08.2013 20:18:15
Luna
Das ist das Makro womit ich die Daten aktualisiere.
Sub Aus_Allen()
If MsgBox("Aktualisieren?", vbYesNo) = vbNo Then Exit Sub
Call RufMichAuf
Dim strDatei As String, strPfad As String, strTyp As String
Dim wbX As Workbook, wksX As Worksheet, wksN As Worksheet
Dim lngCount As Long
Application.ScreenUpdating = False
strPfad = "C:\Users 'Pfad anpassen
strTyp = "xlsm" 'Dareityp anpassen
Set wksN = ThisWorkbook.Sheets(4) 'Zieltabelle
lngCount = 2 'Startzeile in der Zieltabelle
wksN.Range(wksN.Rows(lngCount), wksN.Rows(wksN.UsedRange.Rows.Count + lngCount)).Delete
strDatei = Dir(strPfad & "\*." & strTyp)
Do Until strDatei = ""
Set wbX = Workbooks.Open(strPfad & "\" & strDatei)
For iWks = 5 To wbX.Sheets.Count
Set wksX = wbX.Sheets(iWks)
wksN.Cells(lngCount, 2) = wksX.Cells(3, 1) 'Zelle A3
wksN.Cells(lngCount, 3) = wksX.Cells(2, 3) 'Zelle C2
wksN.Cells(lngCount, 5) = wksX.Cells(1, 3) 'Zelle C1
wksN.Cells(lngCount, 4) = wksX.Cells(2, 4) 'Zelle D2
wksN.Cells(lngCount, 6) = wksX.Cells(2, 3) 'Zelle C2
wksN.Cells(lngCount, 7) = wksX.Cells(3, 1) 'Zelle A3
lngCount = lngCount + 1
Next iWks
wbX.Close False
strDatei = Dir
Loop
Application.ScreenUpdating = True
End Sub
Luna